Aha! It worked! Thank you so much for your help!

Yes, I'll post it below, but now I have a new problem. My report is set up into 2 groups, employees by department, and employees by employee number. I had to add another variable just to add together the indirect hours only for each, employee, department and the report footer. It's adding up the employee totals correctly, but on the department and report total it is ignoring the last record. This happens for both the total indirect and direct, and the total indirect hours formulas.

This is what the group direct and indirect total hours looks like:

whileprintingrecords;
global numbervar nTotalHrsg:= nTotalHrsg + If isnull({jobtran.ind_code}) then {jobtran.a_hrs}
else if {jobtran.ind_code}='LUN'
    then 0 else {jobtran.a_hrs};

nTotalHrsg;



This is what the group indirect total looks like:

whileprintingrecords;
global numbervar nIndTotalHrsG1f:= nIndTotalHrsG1f + if {jobtran.ind_code}='LUN'
    then 0 else {jobtran.a_hrs};

nIndTotalHrsG1f;

Edited by bigburb - 09 Oct 2009 at 6:41am

variables are not my thing but I have seen the a double add on the last row and it usually has to do with the the last part of the statement and not using a seperate display formula.