UrsulaLlaveria
6 years agoQrew Assistant Captain
toFormattedText rounding and changing hard coded number in formula field
Hi All,
I am attempting to format a numeric field in a formula-text. Using the example for toFormattedText: ToFormattedText(1234567.89,"comma_dot"), my response should be "1,234,567.89". So why is it that when I display that field on the form, it is displaying: 1,234,567.9 !?!?!?!?!
I tried to use this formula to convert a currency field, and it is rounding it to the first decimal point. Any ideas what is going on?
------------------------------
Ursula
------------------------------
I am attempting to format a numeric field in a formula-text. Using the example for toFormattedText: ToFormattedText(1234567.89,"comma_dot"), my response should be "1,234,567.89". So why is it that when I display that field on the form, it is displaying: 1,234,567.9 !?!?!?!?!
I tried to use this formula to convert a currency field, and it is rounding it to the first decimal point. Any ideas what is going on?
------------------------------
Ursula
------------------------------