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