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!
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. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.