Convert Percent Formula to Text Formula
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 trie...
Forum Discussion
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
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