remove negative value

[bsbernabe]

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

[MK_QSL]

Use something like below

IF(SUM(Quantity)>0,SUM(Quantity))

or

SUM({<Item = {"=SUM(Quantity)>0"}>}Quantity)

[shiveshsingh]

May be this expression

=Sum({<Item = {"=Sum(Quantity)>0"}>}Quantity)