Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to Exclude zero and negative values in the Expression
In expression try like
if(USD>0,Sum(USD))
Regards,
In expression try like
if(USD>0,Sum(USD))
Regards,
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)
HI,
You can write a simple if condition in your expression as below
if(USD>0,Sum(USD))
Can some one help me, result should be like this in the screenshot, attached source for your reference.
Perhaps this? I didn't test due to there is no S/W in my machine
Sum({<[Cus ID] = {"=Sum(USD)>0"}>} USD)
did you try any of the above solution?
Find the attached file.
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.
Thanks, the below one is working in background expression
if(USD>0,USD) as Flag