Suppress rows when blank values
We have below sample data
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.