Ok, this is a strange one. I hope I'm just overlooking something.
I have 3 fields in each row of a table (non-repeating). There are many rows, and the fields are ListPrice, Discount, and FinalPrice. Of my many rows, the FinalPrice fields has the same formula, but they reference their respective ListPrice and Discount fields to get the calculation result.
Here's the formula: ListPrice * (1 - Discount)
Pretty simple huh? Now, all of the ListPrice and FinalPrice fields are set to "Decimal" Data Type and are "Currency" with 2 decimal places and a comma separator.
All of the Decimal fields are set to "Decimal" Data Type and are "Percentage" with 2 decimal places and a comma separator.
Of the 5 rows in my table, 3 of them calculate perfectly. The strange part is that 2 rows do not. They give me an error "NaN" when I preview.
I have tried different formulas to see if the field was somehow screwed up, and they worked. I even tried setting their default values to equal ListPrice or Discount, and the numbers came through just fine. I also tried multiplying ListPrice * Discount, and that did not come out correctly. I think it has something to do with the number formatting, but I'm not sure.
I was wondering if anyone had any experience with this error, and why it occurs.
Thanks for any help!