I’m wondering if there’s a way of achieving this :
I have an event with a property that I need to SUM. I can do that with PROPSUM(A) without problem. The thing is that I need to add a cap to that SUM (maximum amount).
I would need something like MAX(PROPSUM(A),cap), where I could get :
- The value of PROPSUM(A) if PROPSUM(A) < cap
- The value of cap if PROPSUM(A) > cap
I have tried to achieve this in many ways but I can’t find a proper way to do it.
Thanks a lot for the help !