Forum Discussion

MichelleChapman's avatar
MichelleChapman
Qrew Assistant Captain
7 years ago

Converting Percent in one field to a Number in another field

I see formulas for similar functions but nothing for working with converting percentages "to number". I need to convert a field that shows 40% (or whatever that percentage is) to a separate field that...
Formulas and functions
JakeRattner2's avatar
JakeRattner2
Qrew Trainee
7 years ago
What is the field type you are converting?  The way you're proposing will work, but if the value is being stored as text it will limit your ability to report on it.  

Although, if what you have is working, you could just convert the formula field to "formula numeric' and update the formula to:

ToNumber(ToText([My Percent Field]))

Jake Rattner | Solutions Architect
(847) 927-1427 | jrattner@quandarycg.com
Quandary Knowledge Base