# Calculate formula

I am trying to calculate a formula based on the selection in a dropdown. In the blend percentages dropdown, the user can select anything from 100% to 25-25-25-25% blend percentage. According to which blend percentage the user selects, it changes how I need to calculate the formula. Each blend percentage has a certain variable that I need to times by either .50, .33, .25 etc.

I am trying to figure out a way to have a hidden input box that takes the blend percentage selected by the user, and input a certain value based on their selection. For example, if the user selects â€ś75%-25%â€ť, the input field will show .75. I will then use that input field to run my calculation off of.

Any suggestions would be greatly appreciated!

Thanks,
Scott

Hey Scott,

Youâ€™re on the right track. Have an input element with â€śthis element is visible on page loadâ€ť unchecked. And use conditions to set different initial content values based on the dropdown selection.

For example: when dropdownâ€™s value is â€ś50%-50%â€ť > initial content = .50

Just remember that the dropdown value in the conditions need to be written exactly as you have written it in the dropdown element (case-sensitive). So create a different condition for each dropdown value.

If you want to consolidate this a little and/or if these blend percentages are saved to your database under a Blend Percentage type, you could also just add another field to store the multiplier value. Then you wouldnâ€™t need conditions. Just set the default initial content to â€śDropdown valueâ€™s multiplierâ€ť

Hope this helps!

Gaby | Coaching Bubble

@romanmg
Thatâ€™s perfect!! Thank you. I was able to get the formula to calculate correctly using states as well.

Do you know how I can round a number? I see the :round to option, but not sure what to put after it. The number I am currently getting from my formula is quite long, more than 10 decimal points. I want it to be a whole number.

Thanks!!

1 Like

The number you put after the :rounded function is the number of places after the decimal you want included.

If you want a whole number put â€ś0â€ť, indicating no places after the decimal

Geoff | Wolfer Tech
Check out
The Best Selling Bubble Template
The Most Used Bubble Template (FREE)

1 Like

@gf_wolfer exactly what I wanted! Thank you. Iâ€™ll give it a shot.

Gaby, could you elaborate on how to actually set initial values to drop downs? I am stuck here:

I could set the value (in fact answer of current user) for other input fields but not for this one.