Summary field question
I was wondering if it would be possible to pull values from a row before in a table. Say I have the following column:
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:
Can I do this in FileMaker?
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 ) )