Included all applicable columns in the data grouping. Tested the script and the results are now in tally with JDA data and with the Validation.TXT file. Applied the debugged script in the Sales Per Counter Per Day PRPT and sent a feedback to sir Mike about the fix.