How do I make an existing line item a subtotal of other line items? Line items below: - Opening Stock - Purchases - Issue of Stock - Closing Stock Formula should be: Opening Stock + Purchases + Issue of Stock = Closing Stock
Select the Closing Stock line item and double click in the formula bar so it is in edit mode, then click on each of the line items you want included in your caclulation and you will see them being added to the formula bar. Then press the green tick to enter the formula.
I use the forum example as a training platform, here is the way I set it up :
Opening Balance = PREVIOUS(closing balance) + Init Value
Closing balance = Opening Balance + Input + Output
Remember to use summary method for relevant Year End amounts.