4 Replies Latest reply on Apr 22, 2013 3:15 PM by MattMatthews

    Find on Calculation Field for summary of Portal records not working

    MattMatthews

      Summary

      Find on Calculation Field for summary of Portal records not working

      Product

      FileMaker Pro

      Version

      12.0v3

      Operating system version

      Win7

      Description of the issue

      I have a calculation field that add multiple summary fields together (Amount_Due_Total + Donation_Total - Amount_Paid_Total) from a detail table (or portal).  All fields are set = Number.  The calculation field on the Layout is working correctly but when I do a 'Find' where the number (or balance) is >0 I don't get correct results;  It brings back records that are less than or equal 0.  All the fields are set to not evaluate if empty and none of the summary fields are 'running totals'.  I have tried to evaluate the data for rounding issues but don't see any.  Is this a bug or is there another way to define the field to work correctly with a Find?

      Steps to reproduce the problem

      see above

      Expected result

      see above

      Actual result

      see above

      Exact text of any error message(s) that appear

      no error

      Configuration information

      Note: this file is basically an invoicing solution with an invoice header and then invoice lines and I'm trying to find all the invoices with a balance (total on the invoice lines with a balance due) so I can send collection letters.

      Workaround

      I'm thinking if writing a script to set a field in the Header table equal to the balance of the sum of detail lines table but then I would have to run this script often so this is not the desired solution.