I have a calculated member "RX Scores" and a Dimension [Rx Flag]
which has value 'Y' and 'N'

So I need to change the calculation in calculated member based on
"Y" or "N" value.

Below is my Calculated Members "RX Score"

iif([Rx Flag] value is "N" , Use different calucation, Use
different calucation)

How can we write a Calculated Members with above logic?

Any help would be appericate!!!

Thanks
Sam

iif([dimension].[level].currentmember is [dimension].[level].[member], TRUE,
FALSE)

so something like should work for you:
iif([Rx Flag].[Rx Flag].currentmember is [Rx Flag].[Rx Flag].&[Y], TRUE,
FALSE)

regarding if you use AS2000 or 2005 the currentmember formula is:
2000: [Rx Flag].currentmember
2005: [Rx Flag].[Rx Flag].currentmember

I hope this helps you


"Sam" <msam77 (AT) gmail (DOT) com> wrote