Skip to main content
Question

ToText Formula rounding my number up

  • April 2, 2019
  • 0 replies
  • 73 views
Forum|alt.badge.img
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, = 1548778.25. In the formula field, ToText([Currency]) = 1548778.3.
BUT
If I were to do  = 45.28, it converts it correctly to 45.28 
Why is this happening and how can I stop it??
    This topic has been closed for replies.

    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))
      Terms & ConditionsAccessibility statement