Dear all,

Any idea how to set the formula of a calculated member for if a dimension
value is equal to say 'N/A', then the calculated value is set to 0 ?
I tried the formula as below, although syntax is ok, but after the cube is
processed, the result is always error.
Any idea ?

Iif( [Census Gender].[Gender All].&[All Gender].&[N/A], 0,
[Measures].[Census Pop])


Thanks in advance.
Mag

try something like this:

Iif([Census Gender].CurrentMember is [Census Gender].[Gender All].&[All
Gender].&[N/A], 0,
[Measures].[Census Pop])

or
Iif([Census Gender].CurrentMember.UniqueName = [Census Gender].[Gender
All].&[All Gender].&[N/A].UniqueName , 0,
[Measures].[Census Pop])


"magwg" <magwg (AT) discussions (DOT) microsoft.com> wrote

Jéjé,

Thanks a lot. I can have 0 value for N/A, however the rollup sum of the
calculated measure for dimension 'Gender' is still sum of all original values
of different gender including 'N/A', how can tackle this ? Please advise.



"Jéjé" wrote:

the formula don't overide the sum applied at the "all gender" level.
this level still contin the sum of each gender including the "N/A" value


"magwg" <magwg (AT) discussions (DOT) microsoft.com> wrote