1 2 Previous Next 16 Replies Latest reply on Nov 23, 2015 7:24 AM by DavidJondreau

    Sum Related Records

    director@charlesmoore.org

      Is it possible to create a calculation that sums the number of related records that share a unique ID?

       

      If I have a table <grocery bag>, filled with <items>.

       

      <items> can have unique IDs for "fruit" or "vegetables".

       

      So if your shopping back has (6) cherries and (10) bananas) sharing the uniqueID type-1000 (fruit), is there a way for the shopping cart to calculate there are a total of (16) pieces of fruit, even though there are only (2) records for these <items>.  (Which is to say FM is counting the number of records that contain the uniqueID field "type-1000"?

       

      Thanks so much for your help!

        1 2 Previous Next