Filter Negative Values before Aggregation

[bc123456]

Hi - Below is a sample data set along with what I am getting vs. what I want. How can I filter the negative values out before the sum aggregation? The problem is Value is an expression. Let's say it's Value1-Value2= Value

Thanks for your help!

[pedrobergo]

Hi @bc123456 

You can use Set Analysis:

Sum({<Value={">0"}>}Value)

Or just using If

Sum( if(Value>0,Value,0))

[],

Pedro

[MarcoWedel]

another option might be:

Sum(RangeMax(Value,0))