Can you sum a Line Item Subset?

ChrisMcCarthy · 2024-03-07T10:30:02+00:00

There was an error rendering this rich post.

Just to give some context, we have the line item subset shown in screenshot and this essentially forms a detailed balance sheet before we have any consolidation adjustments.

We perform the consolidation adjustments in another module. This module uses the line item subset highlighted above.

Then want to be able to pick up the consolidated balance value but in a more summarised form to enable board reporting, example combining the Property, Plant, Equipment line, with the Goodwill and Intangibles, and so on.

Any advice would be greatly appreciated.

Accepted answers

All comments

SriNitya

Create Total line item in module add the items of Non current assets and enable it in your Line item Subset

PujithaB

As @SriNitya mentioned, you can create any number of Summary items such as Current Assets, Non Current Assets etc., in the source Module of LIS, And Once you enable the Individual Lineitems belonging to all the totals in the LIS Creation , all the total Lineitems will be automatically Enabled

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…