Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Customer | NET Balance | Credit Amount |
---|---|---|
AA | 100 | 50 |
BB | 300 | 300 |
CC | 400 | 100 |
DD | 200 | 200 |
I have to write an expression to find the count of those customer which have (NET Balance - Credit amount) = 0
New Update please check now
Write Expression like
=Count(if( (([NET Balance]) - ([Credit Amount])) = 0, Customer ))
hi
if the net balance and credit amount are calculated for each customer with sum function then use
sum(aggr(if(sum([Net Balance])-sum([Credit Amount])=0,1,0),Customer))
=Count(DISTINCT {<Customer = {"=SUM([NET Balance])-SUM([Credit Amount])>0"}>}Customer)
Update : Sorry, I misread your question...
=Count(DISTINCT {<Customer = {"=SUM([NET Balance])-SUM([Credit Amount])=0"}>}Customer)