The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group

Slack Signup
Newsletter Optin
Help Desk

If_Else Calculation

Labels

This Discussion is public

Notifications

Apologies if this has been answered already but I couldn't find exactly what I was looking for in the previous posts. I'm trying to add a discount to a calculation or use an if_else statement to return a value.

I'd like to figure out if there is a way to use conditional logic in calculations? For example, I have products that can be purchased in my form and if the total of those purchases add up to $21 or $30 I'd like to subtract $3 from the total. Initially I was trying to do this in a single calculation field where the total was adding the Saved Values from a few fields together and I wanted to apply the discount in that same field, but this has been proving to be a bit more difficult. So instead, I have a subtotal field and based on that subtotal field, I've added a 2nd field for total and would like to subtract an amount of $3, $6, $9, etc. based on whether or not the subtotal value is equal to specific pricing, or else return the subtotal value in the 2nd field.

Hopefully this makes sense? Any assistance would be appreciated as I believe my previous discussion topic was removed 🙁

You can go to http://formi.immofizz.fr and click on TEST5

Subtotal = NB1 + NB2

IF Subtotal < 20
Result = Subtotal
ELSE IF Result < 40
Result = Subtotal - 2
ELSE IF Result >= 40
Result = Subtotal - 5

Is that what you are trying to do?

I use Hide fields + Conditional Test + Dynamic value

Discussion closed.