1 Reply Latest reply on Jul 18, 2012 10:36 PM by philmodjunk

    Help with Calculating Fields in a Found set

    rustyrc

      Title

      Help with Calculating Fields in a Found set

      Post

      Hi there Im new to filemaker and I need some help in calculating fields in a found set. Here's the lowdown, I am developing a system where in the treatment minutes in a clinic gets summed up and becomes part of an equation. To further illustrate th task at hand:

      1) Calculate a date range for the treatment records

      2) After getting the found set, add all the treatment minutes from the found records

      3) perform other calculatons from this found set

       

       

      Thank You! I hope someone can help!

        • 1. Re: Help with Calculating Fields in a Found set
          philmodjunk

          1) Perform a find with criteria like this: 12/1/2011...12/31/2011 to find dates in a date range. This can be done in a script if you use steps like this:

          Enter Find Mode []
          Set Field [YourTable::DateField ; Table::GlobalDate1 & "..." & Table::GlobalDate2 ]
          Perform Find []

          2) A summary field can compute the total of all records in the found set produced by 1)

          3) and what calculations would those be?