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 :Ā
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 !
Hey
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.
Ā
Ā
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
