Skip to Content
0
Jul 14, 2015 at 11:36 AM

Suppress rows when blank values

16 Views

Hi,

We have below sample data

Country KF1 KF2 KF3 Var1 Country1 2 EUR Country2 2 4 Country3

Variable 'Var1' is created in report with formula =if(isnull(KF3);"";[Currency]) as I do not want to display currency if there is no value for KF3

Also I have unchecked 'show rows when all measure values = 0 or empty' as I do not want to display row when all measures are 0 or blank values.

But 2nd(blank) row is still displaying, it is working fine (blank row is suppressing) if I use the currency object instead of variable 'Var1'

Could you please help me to get rid of this issue.

Thank you,

Ranjith