Create Subtotal of Existing Line Items

[PrevContributor]

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

[PrevContributor]

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.

[michel_maurel · Accepted solution]

Hello, I use the forum example as a training platform, here is the way I set it up : Init value Opening Balance = PREVIOUS(closing balance) + Init Value Input Output Closing balance = Opening Balance + Input + Output Remember to use summary method for relevant Year End amounts.