Discussions

Expand all | Collapse all

Converting Percent in one field to a Number in another field

  • 1.  Converting Percent in one field to a Number in another field

    Posted 04-05-2019 13:52
    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 will show as .4. One field shows the percent the agent gets in commission the other field shows the total applications they get credit for...So if he gets 40% credit he gets .4 of an app. I need a formula to convert [Primary Rep %] to the [Primary App] (formula-numeric field).


  • 2.  RE: Converting Percent in one field to a Number in another field

    Posted 04-05-2019 14:23
    Figured it out...so simple to... To Text([My Percent Field])


  • 3.  RE: Converting Percent in one field to a Number in another field

    Posted 04-08-2019 17:42
    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