Quarter Apportionment

CommunityMember111277

Hi Team,

I have couple of queries regarding the below snapshot

Both Q1 & Q2 has 91 days, however the quarter balance is different? Can anyone explain the difference?
Are we calculating values for quarters first, & then segregating the quarterly values into monthly or is the other way around?
What does "Quarter Apportionment" means? Is it like "Total yearly value divided by 4"? 400 / 4 = 100 per quarters. If yes, then how come quarter values are different for each quarters

Thanks

Accepted answers

All comments

ManjunathKN

Hi @CommunityMember111277

-Although both quarter has 91 days, the value depends on other part of formula like commission %.

-there is no segregation here. Month values depends on quarter apportion for each month and commission and similarly for quarter for quarter apportion and quarter commission. This is when you keep the summary as formula,

-quarter apportion for month is quarter days/month days

Thanks,

Manjunath

CommunityMember111277

HI ManjunathKN,

Thanks for your inputs..

When you are saying "other part of the formula" like commission etc. - is the formula fixed or flexible?

Example - let say, my commission + others % = 10%, salary 12000

So, my Q1 & Q2 balance should reflect the same = 3000(12000/4) x 10% x 91/366

What am I missing here? The only way the quarters can have different values if commission% is different for every quarter/month. If yes, then how does it sum up to yearly commission rate calculation of 10% (example)

Thanks

willridge

Hi, Anaplan will calculate values for months first, then summarise those to quarterly values. It looks like you're getting different quarterly values because something in the monthly calculations isn't evenly phased across all quarters.

Could you share screenshots of the source modules and blueprint views?

ManjunathKN

Hi @CommunityMember111277

What you are stating is true logically. Could you please share the screenshots on blueprints to understand more?

Thanks,

Manjunath

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…