Use a number in a choice field as a multiplier of a number field?

How can this be done?

- Mr_K
- 4 yrs ago
- Reported - view
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?
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Reported - view
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
- Mr_K
- 4 yrs ago
- Reported - view
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?
- BugTrapper
- 4 yrs ago
- Reported - view
number(replace(text(Choicefield),"%",""))*Numberfield
- Mr_K
- 4 yrs ago
- Reported - view
Something is still missing. I get this error:
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Reported - view
You forgot a ) after Commission.
- Mr_K
- 4 yrs ago
- Reported - view
Yikes! Yes, I did. I have it working now. Thanks, everyone for the help.

Content aside