Question

Max between 2 numbers (FORMULA)

  • 22 September 2021
  • 1 reply
  • 24 views

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 !


1 reply

Userlevel 6
Badge +4

Hey @tomash,

I don’t think that a conditional MAX formula use case over a PROPSUM is currently supported in custom formulas.

You can also try using some context from this post here:

 

The derived properties feature has a MAX function using which you can try using if you haven’t already, but that will output a new property which will give you the value of the max between a property value and your cap value for that event. Not sure if this helps your case since the main value you want to work upon is the PROPSUM as a whole value.

 

 

Reply