Exclude zero and negative values

[Anonymous]

How to Exclude zero and negative values in the Expression

[PrashantSangle · Accepted solution]

In expression try like

if(USD>0,Sum(USD))

Regards,

[neha_shirsath]

You can create flag in script like-

if(isnull(USD) or USD<0,1,0) as flag

ANd use this flah in your expression like-

sum({<Flag= {0}>}USD)

[vishalmanu]

HI,

You can write a simple if condition in your expression as below

if(USD>0,Sum(USD))

[Anonymous]

Can some one help me, result should be like this in the screenshot, attached source for your reference.

[Anil_Babu_Samineni]

Perhaps this? I didn't test due to there is no S/W in my machine

Sum({<[Cus ID] = {"=Sum(USD)>0"}>} USD)

[PrashantSangle]

did you try any of the above solution?

[neha_shirsath]

Find the attached file.

[vishalmanu]

Hi,

You can try using the expression that i have posted above. its working and i am able to get the result as per the screenshot posted by you. Or you can try using the expression posted by Anil Babu. Both the expressions will give you the same output.

[Anonymous]

Thanks, the below one is working in background expression

if(USD>0,USD) as Flag

Re: Exclude zero and negative values