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

Accepted answers

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.

All comments

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

Quick Links

Can you help?

Unanswered questions

How do I create a "Dynamic Bulk Copy" Action?
I'm looking to create a bulk copy action that allows me to select the source and target list items at runtime / when the action is run. I have some vague recollection I saw this available at one point with my own eyes, but everywhere I look on Community I find old posts that refer to the feature not existing. However, I do…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385