AnsweredAssumed Answered

Restrict Dollar and Cents to Text with two decimal places only

Question asked by sherab4 on May 27, 2018
Latest reply on May 27, 2018 by sherab4

I have a calculation that can give me a result with 3 places to the right of the decimal point. "If ( Contract To = "Build All Stages" ; Contract Total / 100 * C_B Perc Change - Contract Deposit)". How do I restrict the answer to 2 decimal places. At the moment when I convert this to text the last number can be different by one, for example the calculation may be $148.436 which is $148.44 when taken back to two decimal places, but the figure converted to text will show One Hundred and Forty Eight Dollars and Forty Three Cents. I need this to be One Hundred and Forty Eight Dollars and Forty Four Cents.

Outcomes