I am summing hours for the pay period from the PRDISTRB table with drill down and occasionally I get duplicate hours being printed and summed. Seems to happen after an employee has been moved from one position code to another. Not sure if that is always the case.
I have looked at the PRDISTRB table and there are not duplicate records in the file.
if {PRDISTRIB.PER_END_DATE}={Command.PER_END_DATE2} then
{PRDISTRIB.R_HOURS}
above is my formula, then I sum that
IP Logged