Skip to main content
Question

Roll up last 12 records

  • July 16, 2019
  • 0 replies
  • 15 views
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 related record.
      This topic has been closed for replies.

      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]




      Terms & ConditionsAccessibility statement