Create Subtotal of Existing Line Items

PrevContributor
PrevContributor
in Modeling

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

Tagged:

Best Answer

  • michel_maurel
    michel_maurel
    Answer ✓
    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.

Answers

  • PrevContributor
    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.

Categories