13 Replies Latest reply on Jan 3, 2012 6:18 PM by Joe Mako

    using latest versions of records only

    Zach Leber

      We have a database of records some of which have multiple versions and we want to perform calculations using only the latest version of each.  For example, see the attached screen shot and workbook which show a list of book chapters, some with multiple versions, all with word counts.  How to get the total word count of the latest versions only?  Looking for 370 as the answer.

       

      
       [Chapter] [Version] [Words]
      1            1            200
      1            2            190
      2            1            180