Count of customers that have values higher than 0

[Ulviyya]

Hello everybody,

I have a problem regarding Count function.

I have data stored in several columns: Year, Month, Customer_no and several Deposit types and need to count a number of distinct customers that have sum of all Deposit types>0. When I write if((Deposit1+Deposit2+Deposit3)>0,count(distinct customer_no))) I get 0.Please help, I have read many topics regarding count but none of them helped me with this issue.

Thanks in advance for any replies.

[tresesco · Accepted solution]

Try like:

count(distinct {<customer_no={"=Sum(Deposit1+Deposit2+Deposit3)>0"}>} customer_no)

[Ulviyya]

It worked!!!  Many thanks!!!