Summary Methods Based On Line Items - Product as an example or Weighted totals

Hi All,

I feel that the summary methods in Anaplan could be improved further by including more flexible options to use other line items (same dimensionality) to influence summary method.

For example on a model I have been building recently, many of the summaries require the product of 2 line items divided by the total of one to create a weighted average summary. In modelling Debt this is quite common.

There are workarounds to achieve this but native functionality would better design and ease in building models.

Also I'm sure there are many different scenarios which apply to using different line items as a summary or a combination or formulas at the summary level only.

Thanks,

Usman

Comments

Adithya S

@usman.zia

This feature would certainly help in many use cases. One such use case would be for filtered items to give the total in the summary only for those items which are true and it can be an option to choose from the summary method (Summary based on filter). Nice idea.

wwood

Another vote for this functionality.

AJAlejandrino

What is the process to have this considered more heavily (as it's a very basic and important part of planning)?

Quick Links

New ideas

Administration Console: Keep Last login in Date format, on top of new format
It is great to know how old is the Last Login, but: 1.It would be great to keep the old Date format as well, to be able to make more easily some ad hoc analysis (older than X days, months etc…, as shown in example further below). The filter on new format is not possible and would not be meaningfull. 2.It would be great to…
Synchronized Scroll on Worksheet with an Expanded Grid Card
It would be incredibly helpful to have the ability to group the main worksheet grid with an expanded card for synchronized horizontal scrolling. Use Case: In my worksheet, I have the Time dimension on columns and a list on rows in the main grid. I also use an expanded grid card to show a different breakdown—still by Time,…
Line Item Spacing within a Text Box
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Option to adjust line spacing within a text box. Who is this impacting? (ex. model builders, solution architects, partners, admins,…