Discussions

Expand all | Collapse all

ToText Formula rounding my number up

  • 1.  ToText Formula rounding my number up

    Posted 04-01-2019 20:55
    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??
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1783497/RackMultipart20190401-88025-aitcb4-toText_Rounding_inline.PNG?1554152164">


  • 2.  RE: ToText Formula rounding my number up

    Posted 04-01-2019 20:58
    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))


  • 3.  RE: ToText Formula rounding my number up

    Posted 04-01-2019 20:59
    thank you, you beautiful creature. I am definitely having a face-palm moment, I knew it was super simple. 


  • 4.  RE: ToText Formula rounding my number up

    Posted 04-01-2019 21:03
    I guess that is better than being called "the creature from the black lagoon".



  • 5.  RE: ToText Formula rounding my number up

    Posted 04-01-2019 21:04
    Agreed!