var runningTotal = 0; var jobId = {!id}; //get the labor {!#LOOP_BEGIN.R101148181} var laborTotal = rbv_api.selectNumber("SELECT sum(labor_hours * expression_rate) as total FROM ccTimesheet_labor where R101148160 = ? ", {!R101148181.id}); runningTotal += laborTotal; var concreteTotal = rbv_api.selectNumber("SELECT sum(((concrete_rate * yards) + fuel_charge + environmental_fee) * 1.06) as total FROM ccTimesheet_concrete where R101464920 = ? ", {!R101148181.id}); rbv_api.println(concreteTotal); runningTotal += concreteTotal; var miscTotal = rbv_api.selectNumber("SELECT sum(misc_rate * misc_quantity) as total FROM ccTimesheet_misc where R101406810 = ? ", {!R101148181.id}); runningTotal += miscTotal; {!#LOOP_END.R101148181} return runningTotal;