breakback when using average in the summary

Hi everyone,

When building a model, I came across the need to do breakback with an average as summary method, but I found that this option is unavailable. Basically, what I wanted was to be able to adjust the values month by month and see the influence that it has on the average of the full year and also be able to adjust the final average of the year and see the influence that it would have monthly.

If I was doing a sum it would be just to do the breakback but being that I need the yearly average it is not possible.

Is there any way to do the breakback using the average? If not possible, does anyone know how I can get around this problem?

Thank you in advance

Accepted answers

All comments

Vinay VaradarajM

Hi @ManuelSampaio ,

I tried replicating the problem you described, and I think one of the ways you can achieve the result is as shown below:

1. Create a different line item which can Display the average (Average Chargeability)

2. Since you would like to do a 'what-if' by being able to input values at yearly level as well, create a line item (Desired Avg) where you want to input the desired average value

3. This will drive the 'Target Sum' line item, which you can eventually paste in the breakback at yearly level

Step1

Screenshot 2022-11-30 at 11.35.39 AM.png

Step2

Screenshot 2022-11-30 at 11.46.56 AM.png

Hope this helps!

vinayvm

ManuelSampaio

Hi @Vinay VaradarajM

Thank you for your answer!

you also share what you have done in blueprint view? So I can understand better what you have done.

Thank you in advance

Vinay VaradarajM

Hi @ManuelSampaio ,

Here's the blueprint view:

Screenshot 2022-11-30 at 9.11.37 PM.png

Regards,

vinayvm

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…