Convert Percent Formula to Text Formula

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
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?

Photo of Heather Bryant

Heather Bryant

  • 952 Points 500 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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