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

    Sum Related Records


      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