Omitting Zero values for counting

[nevilledhamsiri]

Dear Friends

It is 10 the count with zeros. But I need to avoid zeros & the out put needs to be 6 which is the count after zeros are excluded. The formula used with where clause seems to be not working. Could you please see where the error is?

Thnaks

Neville

[Taoufiq_Zarra · Accepted solution]

Hi Neville,

whene you use len(field)>0  it's particularly when its null,

so in your case :

Data:

LOAD * INLINE [
    BRANCH, PAID
    RA, 0
    RA, 100
    RA, 200
    RA, 1000
    RA, 2000
    RA, 2500
    RA, 4500
]where Fabs(PAID)>0;

output :

[nevilledhamsiri]

Hi Taoufiq,

Very happy that you provide us quick answers. You simply doing well. The answer for my issue is resolved. What Fabs does in this respect which is something we use to handle growth related issues where two figures are matched related two two different periods.  

Thanks you very much

Neville

[Taoufiq_Zarra]

Hi @nevilledhamsiri 

You can simply use :

Data:

LOAD * INLINE [
BRANCH, PAID
RA, 0
RA, 100
RA, 200
RA, 1000
RA, 2000
RA, 2500
RA, 4500
]where PAID<>0;

but I prefer  absolute values Fabs