Hello. I am having a rounding issue using ToWords. I am using the following formulas:
@BonusPaid:
If {FifthMailing.BONUS BASIS}= "Per Acre" then {FifthMailing.BONUS}*{FifthMailing.NET ACRES} else {FifthMailing.BONUS}
@BonusPaidToDollars:
UpperCase (ToWords(
{@BonusPaid})+" DOLLARS"+ ReplicateString(" ", 50))
Normally, no issues with the above formulas. TODAY, I had a result of the @BonusPaid = $1568.07
HOWEVER, the @BonusPaidToDollars resulted in:
One Thousand Five Hundred Sixty-eight and 06/100 Dollars
Note the difference of 1 cent in the @BonusPaidToDollars amount.
The NetAcres field is six decimal places with a leading zero.
How do I fix this?
Thanks.