Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Active Contributor
0 Kudos

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.