3 Replies Latest reply: May 15, 2014 10:16 AM by Olly Bond RSS

    Summary with Calculated Fields and Multiple Keys

    tracywalpole _

      I'm a semi newbie with Monarch...

       

      I am working on a report that looks like this (where dept ID and job code are calculated fields, pulling this data from a long string of text):

       

      beginning date    ending date    dept ID    job code    OT#    hours

      7/28/2013           8/10/2013     500300     01033        1        .25

      7/28/2013           8/10/2013     500300     01028        1     12.00

      7/28/2013           8/10/2013     500300     01033        2        .50

      7/28/2013           8/10/2013     500300     01033        1        .25

       

       

      I made a quick summary but I can't get it to summarize the hours right. I want it to ultimately tell me the totals of OT hours based on dept ID and job codes. So all of the 500300/01033 OT 1 - give me a total hours, all of the 500300/01033 OT 2 - give me a total hours, etc... for each dept ID and each job code within that dept ID. Does that make sense?

       

      I feel like I've tried everything I can to get the summary right but I know I'm not doing something right. Any help would be greatly appreciated.