We want to create a formula to calculate the value of a field under the following conditions:
"If the value of the field with ID=23 is = to 2 months, then increase the value of the field with ID 24 by 10% and divide by 2, if the value of the field with ID=23 is = to 3 months, then increase the value of the field with ID 24 by 10% and divide by 3, and so… "
We have entered the following formula in a field and it does not work for us, could you tell us how should be the structure of the formula?
Do note that Advanced Calculations cannot do if/elseif statements on strings, only numeric values. Assuming your 2/3/4 month values are in a choice-based field, you’ll need to set the values of those fields to be integers, like this: