AnsweredAssumed Answered

Sum Related Records

Question asked by on Nov 23, 2015
Latest reply on Nov 23, 2015 by DavidJondreau

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!