Calculation is Throwing an Error

[Scandrolico]

I am making a simple form to take a contract amount, less payment already received, less this payment should total the balance due.  When I do the calculation ContractAmount0 - PaymentReceived0 - ThisPayment0 is giving this error:  The value entered does not match the format of the field [BalDue0].  

Everything is set to number, 2 decimal places, with the $ symbol.  It's rounding somehow.  

[try67]

Is the value of all of those fields a number? No other characters?

[Scandrolico]

Just a decimal is included.

[try67]

Can you share the actual file with us?

You can attach it to the original message using the tiny paperclip icon at the bottom when you edit it, or upload it to a file-sharing website (like Dropbox, Google Drive, Adobe Cloud, etc.), generate a share link and then post it here.

[Thom Parker · Accepted solution]

You have hit a very interesting artifact of number representation in Acrobat. This is actually quite rare.

The value should be zero, but the first subtraction yields ".93999999994" instead of ".94".  So the next subtraction, instead of going to zero, converts the calculation into scientific notation.  The built-in formatting should just convert this to zero, but it wasn't built to handle it, so displays the errror.

The solution is to use your own formatting script. This will work.

event.value = util.printf("$%,0.2f",event.value);

[Scandrolico]

Thank you for figuring this out, but this may be a dumb question, but where do I put event.value = util.printf("$%,0.2f",event.value); does it go into the custom calculation script?

[Thom Parker]

No, it goes into the Custom Format Script. 

[Scandrolico]

Thank you!!  That did work! I appreciate your help!

[Bernd Alheit]

What does you get when you set the format to None.