Set analysis not working inside IF

[martynlloyd]

Hi Everyone,

I have a dimension "Dimension" with 4 values:

Units

Registrations

Share

TY v LY

If I have an expression: Sum({$<Dimension={'Units','Registrations','Share'}>} Measure)

- that works fine

I want a different format for the Share, so I use:

If (Dimension='Share', Num(Sum({$<Dimension={'Units','Registrations','Share'}>} Measure),'##0.0%'),Sum({$<Dimension={'Units','Registrations','Share'}>} Measure))

So now I get ALL 4 values - the set analysis is ignored.

Why?

best regards,

Marty.

[robert_mika]

No sure but the only difference between the False-and  true is the format.

So if the Dimension is Share you will get % otherwise get Expression format.

Could you post your data or screenshot?

[martynlloyd]

Screenshots

[sunny_talwar · Accepted solution]

Make sure Suppress Zero-Values on Presentation tab is checked:

[martynlloyd]

Thanks!

I'm trying to do two incompatible things at the same time - I'll have to solve that in the script...

Marty.

[sunny_talwar]

Or try using a calculated dimension for one of them and suppress is from there.

If(Match(Dimension, 'Units', 'Registrations', 'Shares'), Dimension)

and select "Suppress When Value Is Null" option on the Dimensions tab. and then you won't have to worry about z15 v 14 and you will be able to uncheck Suppress Zero Values on presentation tab.

HTH

Best,

Sunny