Is there a way to sum a non-recurring field? I have a detail line that shows employee hours, I have it calculated so that "if hours less than 40 then show hours, if hours greater than 40 then subtract 40 to devise overtime" I have three groupings and need to be able to sub-total by all three groups, but can't because of the "non-recurring" problem, whats the fix?

I had considered a table, and that may be the answer but is there an easier way, and if not, how exactly does one do the "put it in the table and calculate from there?" Any help would be greatly appreciated....