Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Suppress rows when blank values

Hi,

We have below sample data

CountryKF1KF2KF3Var1
Country1 2EUR
Country224
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

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question