Hide 0 value

Hello,

I made a calculed member

with this formule distinctcount([sales order].members)

I would like that the "0" value doesn't appear.

Is it possible ?

Sure. Use the IIF statement in your calculated member to evaluate the value. If yoe return a value of 0, substitute a another value in it's place. You could substitute NULL or even a string such as "n/a".

Good luck,

Bryan

|||

I tried this formule

iif(distinctcount([no appels].members)=0,NULL,distinctcount([no appels].members))

and I have an error :

distinctcount must be used as a function of higher level (most external)

|||

I find the answer,

I created a new calculed member and I could use the iif to exclude the 0 values.

sql