Skip to Content
0
Aug 22, 2017 at 09:54 PM

How would I combine amounts of 2 same wage types off Table RT?

385 Views

On payroll processing, I'd like to add amounts of the same wage types coming from PRT table RT. I want my final results to show only 1 line on this wage type with the total amount.

The 2 lines are:

3 854R Text Description0101 0001 B 08 1,000.00

3 854R Text Description0101 0001 250.00-

ESG 3, Wage type 854R, and cost center 0001, are the same for these 2 lines, however, one has a variable assignment type (B 08), the other does not. For the final RT table, I'd like to see only 1 line:

3 854R Text Description0101 0001 750.00

I very much appreciate any assistance. Thank you.