1 of 1 people found this helpful
use getNthRecord ( Table::Field ; get (RecordNum) - 9 ) to fetch the 9th previoust record etc ..
You could create a text calc field, unstored, where
i = Get ( RecordNumber ) ;
GetNthRecord ( primaryID ; i - 9 ) & ¶ &
GetNthRecord ( primaryID ; i - 8 ) & ¶ &
GetNthRecord ( primaryID ; i - 7 ) // etc.
/* Case ( haveFMAdvanced ; writeRecursiveCustomFunction )
does not work with List() */
and use that field for a self-join relationship (YourTable::cLastNineIDs = YourTable_lastNine::primaryID).
This gives you direct access to the previous 9 records, and thus any fields you wish to aggregate.
Thanks FileKraft. That is the function I need.
Thank you erolst. Very cool!