Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try:
Count( {<ELECTRICITY_DUTY-= {0}>} distinct CONNECTION_NO)