Verifying totals and sums within a record
Posted: Tue Mar 10, 2015 11:42 pm
I'm not quite sure why I can't figure out such a trivial thing today... I'm trying to verify that several fields on the record match up to a summed total that is already on the record. If a record's summed total does not add up to the other 3 fields on the same record, I need it removed so it's not processed. The output data set will only show records that field "sum" equals the sum of columns #1, #2 and #3. For example...
Input data set
Expected output dataset
Input data set
Sum | #1| #2| #3
0045|020|010|015
0800|350|200|250
0100|000|000|000
0020|010|010|000
0045|020|010|015
0800|350|200|250
0100|000|000|000
0020|010|010|000
Expected output dataset
Sum | #1| #2| #3
0045|020|010|015
0800|350|200|250
0020|010|010|000
0045|020|010|015
0800|350|200|250
0020|010|010|000