How to add a condition to get rid of zero amount u...

Report Inappropriate Content · ‎2012-08-02

Hi

I am trying to eliminate the zero values in my expression,(so that all the consultants with 0 debts do not get displayed in my table) using the variable that i have created,i tried:

=

Thanks in advance.

if($(vActiveDebt)>0,$(vActiveDebt),0)

How to add a condition to get rid of zero amount using a variable