AnsweredAssumed Answered

Creating 'manual' subsummary calculations

Question asked by PeterAinge on Apr 16, 2013
Latest reply on Apr 16, 2013 by philmodjunk

Title

Creating 'manual' subsummary calculations

Post

     Hi,

     I have a 'timesheet' table where users log their task, and how many hours they have been working on it. i.e. design, research, drawings etc. and this is linked to a job number.

     I want to show total hours spent doing drawings (for example) on a particular job.

     Im thinking Sum(hours if(Code = Drawings))               (Code is the field containing task value list)

     I can do this on a list view using subsummary when sorted by....but want to know how to do this by calculation field.

      

     Thanks

Outcomes