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

michel_maurel

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.