Quote: Looks good to me. Make sure all the fields are Number fields.
Actually, all the fields are money fields. And there is significant weirdness going on.
Instead of numbering the fields, I decided to use the field names. Also, I decided to test it removing the additional charges from the equation. So I ran the following:
Retreive Spec (note the use of subtraction in the calculation:
Subtotal (F0053) not empty
Discount (F0056) less than 0
Add'l Charges (F0059) empty
{Invoice Total<>(F0053-F0056)}
Results: 1813 records.
Then I changed the calculation to addition:
Subtotal (F0053) not empty
Discount (F0056) less than 0
Add'l Charges (F0059) empty
{Invoice Total<>(F0053+F0056)}
Results: 291 records.
I spot checked the results of each return and in every case the arithmetic was
correct. That is, the Subtotal minus the Discout always equaled the Invoice Total, as it's supposed to but
shouldn't if the calculation was working.
Is there something special about money fields that could be causing this?