Use a number in a choice field as a multiplier of a number field?
How can this be done?
7 replies
-
Oh how badly this forum needs an update so a person can edit their post. So my question is:
How can I use a number in a choice field as a multiplier of a number field?
-
Assuming your choice field exists of numbers, we first take the text part of that choice field 'text(choicefield)' and than make it a number so we can calculate with it 'number()' see the complete formula below to put in a formula field.
number(text(Choicefield)) * NumberField
-
Steven, that works great. Thanks. I would like to take this a bit further. My choice field is for commission rates with entries like 50%, 40%, 30%. The formula number(text(Choicefield)) * NumberField works for numbers, but not for numbers with a % sign. Is there a way to strip out the % sign?
-
number(replace(text(Choicefield),"%",""))*Numberfield
-
Something is still missing. I get this error:
-
You forgot a ) after Commission.
-
Yikes! Yes, I did. I have it working now. Thanks, everyone for the help.
Content aside
- 5 yrs agoLast active
- 7Replies
- 1365Views