Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello There,
My concern is so so simple but i don't know how to do that regarding the negative value, i want to remove.
Sample:
Item Quantity
motorcycle 1
car -1
how can i remove/skip THE negative value at the list?
be like below:this is what i want to display.
Item Quantity
motorcycle 1
Best Regards,
Bing
Use something like below
IF(SUM(Quantity)>0,SUM(Quantity))
or
SUM({<Item = {"=SUM(Quantity)>0"}>}Quantity)
May be this expression
=Sum({<Item = {"=Sum(Quantity)>0"}>}Quantity)