Logic issue

[#1]

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.

[tresesco · Accepted solution]

Try like:

Count(distinct  If(ELECTRICITY_DUTY<>0, CONNECTION_NO))

[SunilChauhan]

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

[#4]

Hi,

It is working fine ,but what to do if I want to show my result as 0 .Now it is showing as 1. My actual intention is to show them not to count.

Thanks,

JK

[tresesco]

Try '=' instead of '<>'

[Anonymous]

Hi,

Try in expression:

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

or

In Script:

Load *,
if(len(Trim(ELECTRICITY_DUTY))= 0,0,1) as ELECTRICITYCOUNT
Resident table
group by CONNECTION_NO;

In Expression:

Count(  {< ELECTRICITYCOUNT = 1>}, CONNECTION_NO))

Regards

Neetha

[#7]

Thank you Neetha.

[preminqlik]

hi there,

May be in set analysis like this :

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

[#9]

'=' is the correct answer..Thank you.

[#10]

Your exp :Count( {<ELECTRICITY_DUTY-=0>}, distinct CONNECTION_NO) showing error some where.