I have one datatable with General Ledger data (debits and credits). I’m trying to figure out a way to match the debit and credit transactions based on the location of the entry.
For transactions with a matching location I would like to take the difference between the value in column2 and column3 (which are on separate rows within the same table) based on there shared location.
There’s a sample below of how the data might look. In this example I would want to know that the difference for location 1 is $0, and location 2 is $7.00.
Date Debits Credits Location
08/31/20 100.00 0.00 1
08/31/20 0.00 100.00 1
08/31/20 287.00 0.00 2
08/31/20 0.00 280.00 2
Does anyone know if this is possible?