Summary value for positive values only.

[Wkong]

Hey experts,

I am currently having trouble with making a dashboard. Suppose I have these values.

Where unsold is a calculation by subtracting the inventory by the number of orders.
How can I get the value on the KPI chart to display a summation of only the sum of the positive values?

[tresesco]

Try something like:

Sum({<[Product number]={"=Sum(Inventory)-Sum(Order)>0"}>}(Inventory-Order))

[Wkong]

Using this expression returns: Error in expression, Error in set modifier ad hoc element list: ',' or ')' expected.
Here is what I currently have.
Sum(
{<[Product Number]={Sum(Weight)-Sum([Quantity Kg])>0},
[Refrigration Code]={C},
[Service Kill Code]={NO},
Category={BEEF},
Prodsite={BEE,DIN,RDL,ROC,TOW},
Site={BEE,DIN,RDL,ROC,TOW,JBD,HEM}
>}
(Weight-[Quantity Kg]))

[tresesco]

Sum(
{<[Product Number]={"=Sum(Weight)-Sum([Quantity Kg])>0"},
[Refrigration Code]={C},
[Service Kill Code]={NO},
Category={BEEF},
Prodsite={BEE,DIN,RDL,ROC,TOW},
Site={BEE,DIN,RDL,ROC,TOW,JBD,HEM}
>}
(Weight-[Quantity Kg]))

[BrunPierre]

Try

RangeMax(Sum(Unsold), 0)