4 Replies Latest reply on Jul 4, 2017 10:53 PM by stra21

    Sum of records up to a certain date


      Hello Everyone,


      I am fairly new to filemaker and I have what might be a newbie question. I have a couple of thousands of records in a transactions table. This transactions table has a field called "Units IN".Basically I would like to calculate the sum of the first 50 or 100 records for that field. I have achieved this using an executeSQL statement, but I would like to know if there is another way to perform this task. I was thinking of something along the lines of building a custom recursive function.



      Thanks in advance