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

    Find on Calculation Field for summary of Portal records not working



      Find on Calculation Field for summary of Portal records not working


      FileMaker Pro



      Operating system version


      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.


      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.