Goal: Trying to calculate remaining spent on a budget list where item expenses are grouped per object code. Every object code has a fixed amount of money against which the item expenses are deducted.
Object code ABC = 100,000 Item 1 = $50000 Item 2 = $30000 Remaining Spent = 100,000 - 50,000 = 50,000 50,000 - 30,000 = 20,000
I have 2 lists. One with object codes and their assigned budgets. Another list with item details.
Challenge: How do I deduct expenses from the total amount per object code for every item's actuals?
Level: I am looking for a out of the box solution. Thank You!