ToText Formula rounding my number up
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...
Forum Discussion
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))
ToText(Round([Currency], 0.01))
thank you, you beautiful creature. I am definitely having a face-palm moment, I knew it was super simple.