Compounding across a list

Hi.

I've a question as to how values can be compounded across a list.

i.e. If I was to have a 'Driver list' of 3 items. Each driver item improves sales by 10%, the total improvement to sales is 1.1*1.1*1.1=1.331 or 33.1%.

It is similar to how a product fucntion would work in Execl.

Checking the Anaplan v Excel comparison page here:

https://help.anaplan.com/anapedia/Content/Calculation_Functions/Function%20Usage/Excel%20Comparison.htm?cshid=1565

It suggests it is possible to achieve this using a 'Product' summary method.

However there is no such summary method available in Blueprint.

It is possible to compound across time easily using a previous function, but I see no way to achieve across a list without complex work arounds - hopefully I've missed a simple trick :-)?

Accepted answers

harish_bk

Hi Peter

There is no direct summary format to acheive this.

We need to have one staging line item to get this.

module_view_for_product_36851.png

All comments

harish_bk

It says to create a lineitem Called Summary and use that for calculations.

1) Make sure you have Anaplan time used in the module for the line items.

2) Then you can use offset kind off functions and multiply with growth%

Thanks and Regards

Harish B K

peterbrydges

Hi,

Thank you for the reply. I think this solution only works across time.

In my situation I need to compound items across a list within a single time period. i.e. I cannot use previous or offset functions.

Please see example in original post, where the items which require compounding are a list and not across time.

I'm aware of workarounds using multiple line items, or mapping the list items into a time scale, but all seem very complex for what I hope an easier solution might exist,

Thanks,

Peter

harish_bk

Could you please share screenshot of your module and its blueprint if its okay to see if there are possible solutions

peterbrydges

I think the example is easier to articulate in Excel than with a blueprint screen shot.

Please look at attached file.

Thanks.

Compounding_across_list_example_36713.xlsx

harish_bk

Hi Peter

There is no direct summary format to acheive this.

We need to have one staging line item to get this.

module_view_for_product_36851.png

peterbrydges

This works perfectly!

Many thanks - very smart solution.

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled