Period on Period % Mvmt - Formula Summary Method

Hi Team,

I'm attempting to create a Period on Period % movement in a module using multiple dimensions but I require the summary level/top level to still calculate using the formula rather than Summing all the lower node %'s. When I change the Summary method to % I receive an error

I have tried using Period, Lag & also Lookup for the prior month as a line item in the current module

Is there a way I can display the % movement as a formula for all cells?

Thanks

Accepted answers

ArunManickam

Hello @MarkTurkenburg ,

You mean summary method "Formula", it works well.

You just cannot use SUM/LOOKUP in that formula. You can seperate the SUM/LOOKUP from your formula (by moving it to another line item and reference it).

Can you share your formula.

Thanks

Arun

All comments

ArunManickam

Hello @MarkTurkenburg ,

You mean summary method "Formula", it works well.

You just cannot use SUM/LOOKUP in that formula. You can seperate the SUM/LOOKUP from your formula (by moving it to another line item and reference it).

Can you share your formula.

Thanks

Arun

usman.zia

Hi @MarkTurkenburg

As @ArunManickam suggests it will only be possible to do this by splitting out the individual components of the formula in to separate line items and then creating forumula for which you want to roll up to top level but still using the summary method of formula.

However depending on what you are trying to achieve it could be possible to do this using another line item with different dimensions or only referencing the top level. Or even it could be created in another module but this really does depending what the requirement is. If you can share the exact formula and requirement this will make it easier to advise on.

I hope this helps!

Thanks,

Usman

MarkTurkenburg_*8288

Hi @ArunManickam & @usman.zia ,

I achieved my aim by creating another Line Item with the Lag formula and therefore on my % movement Line Item I could reference both line items (thereby referencing the current period & prior period) & also being able to set the summary to Formula

Thanks for your assistance!

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…