Calculation on top level selection in line item subsets and list item subsets

Hi Anaplan Community,

Currently it is not possible to use a summary top level of a list subset or line item subset in a calculation without using a workaround using a boolean and using the complete list or line item list.

If anaplan had the capability to allow modellers to use the top level in a line item subset or list item subset this would make it easier to calculate and aggregate on a selection of all relevant items to the subset list or line item subset.

This would prove very usefully where you have large lists but need to calculate the summary of a top level of the subset.

Hopefully we can incorporate this in the platform.

Thanks,

Usman

Comments

Miran

Status changed to: In Review

Gwen.pryor

Status changed to: In Review

alexpavel

The summary of the top-level for a subset list can be achieved using a line-item with "Applies To" setup as the Sub-set list. Automatically the Top level will store the summary of the sub-set list.

Is this what you want to achieve or am I missing something?

In the below picture the line-item "Vol Subset" has "Applies To" the subset of the list and the formula "Vol Subset" = "Volumes".

Quick Links

New ideas

Assistance Required for Understanding User License Roles at Tenant Level - Anaplan
Team - As per my understanding, user roles should work as described in the table below, but it is not working as expected. Our expectation is to assign users to a read-only role to restrict their access to a specific model, instead of creating user roles within the model. Any insights would be greatly appreciated. Thank…
Text input on total level
Dears, We would like you to enable text input on text summaries. Could you please consider adding “text input” button for text type summary method? This will help a lot for better navigation, for example when commenting data on total level like P&L total figures.
Ability to Generate Management Reports based on a Hierarchy Chart
We currently have a requirement, working with a very large Bank on their Workforce planning use-case to view their Organisational Hierarchy in a Current and Proposed state. The UX view of the Hierarchy Chart works well, even with very large volumes of data. There is also a requirement to have a Management Report that…