Discussions

Expand all | Collapse all

Convert Percent Formula to Text Formula

  • 1.  Convert Percent Formula to Text Formula

    Posted 12-05-2017 16:14
    I'm working with a numeric formula displaying as a percent. I need to extract this value and use it in a text field. When I put it in there, it displays with a string of 10+ decimal points. 

    I tried converting the percent formula to a simple number formula and a text formula, and they all produce the decimal point string.

    Anyone know how to convert a formula percent field to a value in a text formula field?



  • 2.  RE: Convert Percent Formula to Text Formula

    Posted 12-05-2017 16:37
    No problem

    The value for say 12.475% is actually stored as 0.12475 but just displays as 12.475% for visual purposes.  Or if you show fewer decimals in the field properties it would get shows as say 12.4%

    So use

    ToText(Round ([my percent field],0.01) * 100) and that would give you 12.47

    or

    ToText(Round ([my percent field],0.1) * 100) for 12.4

    or

    ToText(Round ([my percent field]) * 100) for 12


  • 3.  RE: Convert Percent Formula to Text Formula

    Posted 06-18-2019 16:59
    ToText(Round ([my percent field]) * 100) for 12

    I would like for my percent text conversion to display as 12% 
    I am using the formula above
     Please and thank you!


  • 4.  RE: Convert Percent Formula to Text Formula

    Posted 06-18-2019 17:06
    Please disregard above.  I fixed it :)

    New formula:

    ToText(Round([Task 1 Progress])*100)&"% "