Roll up last 12 records
I am wanting to roll up the last 12 records in a relationship but not by month. I am wonder if this is possible with some type of index number. So if I have 34 records only roll up records after 23rd ...
Forum Discussion
You would make a summary field of the Max of the Record ID#. Call it [Max Record ID #1]
Then look that up down to the child record.
Then a new summary of the max Record ID where the Record ID# is less than Call it [Max Record ID# 1]. call it [Max Record ID #2]
just keep doing that until you get to 12.
Then make a summary field to roll up some kind of totals but limit it to where
ANY
[Record ID#] = [Max Record ID #1]
or
[Record ID#] = [Max Record ID #2]
or
....
[Record ID#] = [Max Record ID #12]
Then look that up down to the child record.
Then a new summary of the max Record ID where the Record ID# is less than Call it [Max Record ID# 1]. call it [Max Record ID #2]
just keep doing that until you get to 12.
Then make a summary field to roll up some kind of totals but limit it to where
ANY
[Record ID#] = [Max Record ID #1]
or
[Record ID#] = [Max Record ID #2]
or
....
[Record ID#] = [Max Record ID #12]
Thank you sir!