Is there a function in the casual that allows to set a limit on the increase in value in a given formula?
For example, my formula for increasing the number of users looks like this: Total users * (100% - churn) * User base growth .
Can I add a value limiting the increase to e.g. 100k users to this formula?
2 Likes
Hi Michal, sounds like a great use case for the min()function. If you write something like min(*your formula*,*the upper boundary*), that should prevent the value from exceeding the boundary. In your case, the formula would look something like min(Total users * (100% - churn) * User base growth,100k)
This approach can also be used to set a lower limit using the max() function, a use case would be to prevent the cash on hand from going below zero.