AnsweredAssumed Answered

Adding a single field across multiple records

Question asked by ClaireCollin on Apr 11, 2013
Latest reply on Apr 12, 2013 by philmodjunk

Title

Adding a single field across multiple records

Post

     I have data for a particular part number for each week of a given year.  I need to add the data fields across records by month for each part number. Essentially 4 to 5 records make up 1 month and the data for those records needs to be added together for a total for that month for a specific part number.

     Here is my basic field and data set-up

     SKU    Week     Month    InStock   Committed

     101        1              1              14             0

     101        2              1                5             6

     101        1               2               21            5

     101        2               2                7             8

     102        1               1                4             2

     102        2               1               10            0

     102        1               2               16           11

     102        2               2               32            9

      

     For each month I need to total the In Stock and Committed by SKU

     EX) SKU   Month    InStock   Committed

             101      1               19                6

             101      2               28               13

             102      1               14                2

             102      2               48               20

     I am using this information to populate a portion of a secondary table.  I have tried summary fields but they only sort by either SKU or Month, not by both.  Is there a function or calculation that would allow this addtion to work?

Outcomes