ToText Formula rounding my number up

Question

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??

quickbasecoachd · Answer

I guess that is better than being called "the creature from the black lagoon".

quickbasecoachd · Answer

I can't explain that behaviour (but it might have to do with limitations on how Quick Base handles very large numbers), but try thisToText(Round([Currency], 0.01))

ursulall · Answer

thank you, you beautiful creature. I am definitely having a face-palm moment, I knew it was super simple.&nbsp;

ursulall · Answer

Agreed!&nbsp;

Forum Discussion

ToText Formula rounding my number up

Related Content

Rich Text Button with rounded edge

Delete Formula Button Error

Formula Assistance

Formula Url Buttons

Percent Formula Help