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

[Former Member]

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.

[Former Member]

Thank you very much. I was able to get the desired results.

[former_member193210]

If I understand you correctly, you do not need the variable assignment (B 08) in the final RT.

Then, why not eliminate that split before the WT is transfered from the Input Table (IT) to the Results Table (RT) ?

Find where WT 854R is transfered from IT to RT, and just before that Function, add a PCR that will process WT 854R and use Operation ELIMI X to eliminate the Variable Assignment Split.