The formula for my calculated member is below. It returns a -1.#IND (I'm not
sure what that is) until I drill down into my dimensions to a much narrower
focus than top-level.
==========
IIF(PersonID.CurrentMember is PersonID.[All PersonIDs], (SUM(
Descendants([PersonID].[All PersonIds],2), Measures.[Squared Miles]))^0.5 ,
(PersonID.CurrentMember, Measures.[Squared Miles]) )
==========
I suspect overflow of some kind because [Squared Miles] is very large. The
PersonID is used for grouping. I only use data at the [All PersonIDs] member
so it is the first condition in the IIF that is computing.

If it is overflow, however, I don't get it because I have another set of
calculated members that use [Squared Minutes] and return correct results.
The scale of the squared numbers for MILES is the same as for MINUTES, so I
don't know why one would overflow and not the other.

I'd appreciate help in understanding what this error is and any work arounds
or settings I can try.

Thanks,
Barb

In case someone else has a similar problem, the -1.#ind came from negatives
somewhere in underlying data. You can't square root (^0.5)
a negative number hence the error. Even though [Squared Miles] is always
positive (negative X negative is positive), some math must go deeper to
source to have found negatives.

I needed to transform my fact table to deal with my negative entries.

Barb

"Barb Gengler" wrote: