count expression

[#1]

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

[its_anandrjs]

New Update please check now

Write Expression like

=Count(if( (([NET Balance]) - ([Credit Amount])) = 0,  Customer ))

[lironbaram]

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))

[MK_QSL]

=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)