Create Subtotal of Existing Line Items

Highlighted
Previous Contributor

Create Subtotal of Existing Line Items

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

2 REPLIES 2
Highlighted
Previous Contributor

RE: Create Subtotal of Existing Line Items

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.
Highlighted
Regular Contributor

RE: Create Subtotal of Existing Line Items

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.