IF calculated member

I have a discrete Measure, where 0 = ValueA and ValueB = 'greater than 0'.

The cube is aggregating the Measure but since it is discrete it has lost it's anlaytical value.

I would like to create a calculated member in the cube that adds 1 to the count if the value is greater than 0. Something like...

Iif([discreteMeasure]>0, Add 1 to calculated member count, Add 0 to count)

Any ideas how I can do this?

Thanks

Just do like yousaid, just creat a new count calc member with the following formula

IIF(Discretemeasure>0, 1, 0)

Since this calculated measure will also aggregate as a SUM it should give you the result you are looking for

|||

Adding to Thierry's answer, in AS2005, you can rely on recursion

iif(discretemeasure > 0, discretemeasure+1, 0)

Cheers,

Richard