Matching the Values with different

Question

Hi All,

Can you please help me with logic match if we negative and positive values are zero.

RecordID Assigned_to_Report  PAYMENT  User_Hidden LOT 0                     23.99LOT 1     (4,198.41) LOT 2                            3,412.79        (141.81) LOT 3                            7,148.38    (6,362.76)                 141.81LOT 4     (4,192.04) LOT 5                            4,192.04        (121.69)                 243.38LOT 6     (2,229.23) LOT 7   (14,263.65) LOT 8                          16,492.88        (140.30)                 351.49LOT 9     (5,305.76) LOT 10                            5,233.43          (22.28)                   22.28LOT 11                                  72.33  (17,563.28) LOT 12                                101.44    (1,724.23)             1,660.52LOT 13                          17,206.56        (155.00)                   50.19LOT 14                                255.28    (3,158.43)                   13.52

and attaching the data how we manually matching.

Lalaiah · Answer

@sudak Thanks for the quick response!! if i grouped the mismatch amounts are missing so i am doing manually.

sudak · Answer

Is there something that can be used to group them?  Trying to see if any combination of values on one side can be added up to where the sum matches any combination of values on the other seems not only very difficult, but also runs a risk of grouping incorrect values.   If you had, say, an invoice number in the data, you could use a summary tool to group by the invoice number and sum the two columns, then compare the two sums.