ToText Formula rounding my number up

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
  • (Edited)
I have a currency field that I need to transfer to a text field for a specific reason. When using the toText formula on that field, it rounds up anything over 1 million that has any cents. for example, [TR - First Year Amount] = 1548778.25. In the formula field, ToText([Currency]) = 1548778.3.
BUT
If I were to do [TR - First Year Amount] = 45.28, it converts it correctly to 45.28 
Why is this happening and how can I stop it??
Photo of Ursula Ll

Ursula Ll

  • 1,682 Points 1k badge 2x thumb

Posted 5 months ago

  • 0
  • 1
I can't explain that behaviour (but it might have to do with limitations on how Quick Base handles very large numbers), but try this

ToText(Round([Currency], 0.01))
Photo of Ursula Ll

Ursula Ll

  • 1,682 Points 1k badge 2x thumb
thank you, you beautiful creature. I am definitely having a face-palm moment, I knew it was super simple. 
I guess that is better than being called "the creature from the black lagoon".

(Edited)
Photo of Ursula Ll

Ursula Ll

  • 1,682 Points 1k badge 2x thumb
Agreed!