I have a database in FMP 11 where a parent table is calculating balance due with the subtotal of order items billed from the line items table less the subtotal of payments from the payments table. All of my calculations are correct and I have rounded all to two decimal places in the field calculations. Where payments equal order items, balance due is zero.
Here's the issue... when I find for greater than 0 (>0), or less than zero (<0), I get balance due fields with zero. I thought I had a rounding issue. But when I have FileMaker not show records with a value of zero in the balance due field, these records do not display a zero. So it obviously seeing these fields as zero. I have set the unstored number calculation fields to global storage and then back to unstored again but to no avail. Does anyone have a clue what is going on? I've never seen this before in any version of FileMaker. I'm running FMP 11v3 on a MacBook Pro with 10.5.8.
Thanks for any help.