topic Re: Any way to substitute zero in the case an aggregation is <0 in App Development

Any way to substitute zero in the case an aggregation is <0

elijahabel — Wed, 31 Oct 2018 15:53:20 GMT

I have this issue where we have a complex aggregate calculation (High water mark), and we need to return 0 if the result of the aggregation is less than 0. Obviously i could throw it into an if statement, but i think performance-wise this is not a good idea.

Calc:

Max(Aggr(RangeSum(Above(Sum(Value), 0, RowNo())), Department,(Date, (TEXT, Ascending)))))

If statement solution:

if(Max(Aggr(RangeSum(Above(Sum(Value), 0, RowNo())), Department,(Date, (TEXT, Ascending))))) < 0, 0, Max(Aggr(RangeSum(Above(Sum(Value), 0, RowNo())), Department,(Date, (TEXT, Ascending))))))

Is there a cleaner way to accomplish this?

Re: Any way to substitute zero in the case an aggregation is <0

andrey_krylov — Wed, 31 Oct 2018 16:33:58 GMT

HI Elijah. Maybe RangeMax

RangeMax(Max(Aggr(RangeSum(Above(Sum(Value), 0, RowNo())), Department,(Date, (TEXT, Ascending))))), 0)

Re: Any way to substitute zero in the case an aggregation is <0

elijahabel — Wed, 31 Oct 2018 20:43:06 GMT

Thank you, this solution was perfect