% Total in FY/Q

Hi All,

User wants to input the % in months, I did not enter q1 months%. from Q2- Q4 I have entered 1% each month. I'm finding issues in summary. Q1 should be 0%, Q2, Q3, Q4 should be 1 %. FY24 total should be 3%. How to achieve this solution? I tried all the summary methods , not working out.

Can help to share the thought process on the same?

Thanks.

Accepted answers

All comments

Anurag0911

I might be understanding this wrong but you want to have Average at Quarter level and Sum at Year level as a summary, Is that correct?

aishabhy05

@Anurag0911 , Sum at Q level and year level should be sum as well.

below is the output i'm expecting

CommunityMember123585

if you are expecting sum at Q level then sum will be 3% for Q2 ,Q3 and Q4 and for FY it will be 9%. also as per given sheet by you .pls share the solution if found .

Anurag0911

As mentioned above by Mayank. If you use aggregation as sum you get 3 at Q and 9 at Y. If you want to get output as shown in the image you shared you need to create 2 more modules one at Q level and use Average as an aggregate (1 as an output) and then use another module at Y level and use Sum as an Aggregate method (Both Achievable using Sum function [SUM | Anapedia (anaplan.com)])

Above can be achieved in one module and also with less modules. This is more comprehensive to look at.

Hope this is helpful.

alexpavel

@BlueSky-Wind chaser For a numeric line item, Anaplan can applye simple aggregation methods like SUM, AVG, MAX, and MIN across all the elements of the Time dimension.

From your example, from Months to Quarter you want that Anaplan does some kind of average and from Quarter to Total Year to apply the SUM.

This kind of behavior cannot be solved with the existing simple summary methods.

The ways to overwrite the simple summary methods are the Ratio and Formula.

In your case, the Month level is manual input, so to overwrite what you see at Quarter level or Year Level, you need to use the Ratio method.

You will need to create additional line-items that at Quarter and Year levels shows what you want to see and use Ratio summary method for the input line-item.

Hope it helps

Alex

Quick Links

Can you help?

Unanswered questions

RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…