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
Are you looking to see only those rows where both expressions are not equal to 0?
Like the attached?
WOW ! you are good. the expression is so complicated. Thank you sunny.
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
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.
Check if this works then
Yes , it work fine. Thank you for your help.
Retrieving data ...