Suppress rows when blank values

[former_member224535]

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

[amitrathi239 · Accepted solution]

Hi Use this.

Create one variable Dummy =if(isnull(KF3) and isnull(KF2) and isnull(K13)) then “A”

Apply report filter and condition will be  Dummy is not equal to A.

With this whenever all three KF’s are blank then it will supress the  row.

Amit

[tanveer1]

Please use the formula as

= isnull([KF3])

and filter this variable for not equal to 1

here instead of KF3 you can use whatever object that you dont want to be displayed incase of nulls