1 Reply Latest reply on Jul 11, 2012 4:47 PM by philmodjunk

    Summary field question

    ahcho

      Title

      Summary field question

      Post

      Hello!

      I was wondering if it would be possible to pull values from a row before in a table. Say I have the following column:

      1

      5

      7

      8

      I would like a summary field in a new column that would take the value from the column before and add the value in the current row. Based on the example above, it would look like:

      1     1

      5     6

      7     13

      8     21

      Can I do this in FileMaker?

      Aaron

        • 1. Re: Summary field question
          philmodjunk

          Just to be clear, a row is a record and a column is a field in your example?

          If each row of numbers in your example represents a different record, then a calculation field can use GetNthRecord to refer to data in the previous record.

          Col1Field + If ( Get ( RecordNumber ) = 1 ; 0 ; GetNthRecord ( col1Field ; Get (RecordNumber ) - 1 ) )