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

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 

3 Comments
Community Manager
 
Status changed to: Your support is needed
Regular Contributor
 
Status changed to: Under Investigation
Master Anaplanner/Community Boss

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".

 

 

alexpavel_0-1591864129922.png

 

Users Online
Currently online: 176 members 797 guests
Please welcome our newest community members: