We have below sample dataCountry 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.