Creating 'manual' subsummary calculations
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.