DFSORT Sum and count
Posted: Thu Feb 27, 2014 8:41 pm
Good Morning,
Im new to DFSORT and im trying to sort/count and sum if possible something similar to Sum and count something similar to
My desired outcome would be one line for unique ID, Sum the dollar amounts and Count the Codes
Im new to DFSORT and im trying to sort/count and sum if possible something similar to Sum and count something similar to
ID Reversal Original RCode Ocode
20-009407 0.00 18.00 0420
20-009407 18.00 0.00 0210
20-009407 18.00 0.00 0210
20-009407 0.00 18.00 0420
20-009407 18.00 0.00 0210
20-009407 18.00 0.00 0210
My desired outcome would be one line for unique ID, Sum the dollar amounts and Count the Codes
20-009407 36.00 18.00 1 2