How to hide my table row with zero value ?

[paulyeo11]

Hi All

My Table 2  column 1 & 2  display correct value , but there are many null value , may i know how to remove those null value row.

So that i can compute sum for column base on column 1 and 2 .

My dimension my field is company_ar , I have try surpress when value is null

Paul.

[paulyeo11]

my qvw

[sunny_talwar]

Are you looking to see only those rows where both expressions are not equal to 0?

[sunny_talwar · Accepted solution]

Like the attached?

[paulyeo11]

WOW ! you are good. the expression is so complicated. Thank you sunny.

[sunny_talwar]

I didn't do much paul. Just used both your expressions to check if both of them are greater than 0 or not

If(Exp1 > 0 and Exp2 > 0, Exp1) -> 1st Expression

If(Exp1 > 0 and Exp2 > 0, Exp2) -> 2nd Expression

[paulyeo11]

Hi sunny

I just notice that what i look for is those column for >180 Days row which is zero to be remove.

( Ad those customer debt more then 120 days and Yet Last 5 Month sales zero , are consider very risky customer )

Hope you can help me.

Paul

[sunny_talwar]

Check if this works then

[paulyeo11]

Yes , it work fine. Thank you for your help.