Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Logic issue

Hi all ,

In the below customized report my expression showing wrong results.can any one help me on this

my exp: if(ELECTRICITY_DUTY=0,Count(distinct CONNECTION_NO))

what to do if I want to get only Electricity duty Not counted accounts with 0 symbol, Expression showing all accounts.

Screenshot (11).png

10 Replies
Anonymous
Not applicable
Author

Try:

Count( {<ELECTRICITY_DUTY-= {0}>} distinct CONNECTION_NO)