nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

9.2 Model Build Specifications (I do not see the values being populated quarterly)

Csta

Can someone guide why this is happening?

Accepted answers

AjayM

Hi @Csta ,

You need to do this at account level, not product family and country level
calculate initial account sales target quarterly using PY revenue and initial country sales targets
Calculate quarterly split % of initial account sales target and then apply that % on final account sales target , to get the final account sales target at quarter level
1. Yearvalue will be of help for this

Cheers!

All comments

AjayM

Hi @Csta ,

You need to do this at account level, not product family and country level
calculate initial account sales target quarterly using PY revenue and initial country sales targets
Calculate quarterly split % of initial account sales target and then apply that % on final account sales target , to get the final account sales target at quarter level
1. Yearvalue will be of help for this

Cheers!

RyanD

@AjayM TAR02 is dimensioned by account not product family or country.

RyanD

What line item(s) should you use a lookup with the SYS99 module? I completed this activity using a different method and curious where this technique should be applied. Thank you!

Csta

@RyanD You need to first calculate the Initial Account Sales Target (Bring it from a place where it is already calculated)

For % of Account Sales Target divide the Qtrly Value by Year Value of the Initial Sales Target

Apply the above % value to calculate Final Account Sales Target

Csta

@RyanD Think about using a constant module to lookup the Year

RyanD

@Csta Thank you! I used YEARVALUE to bring in Final Account Sales Target vs. a Lookup using the SYS99 target year line item.

Is the benefit of using the SY99 module that once you update the target year this module will also update which year's final sales target you are pulling in?

Csta

@RyanD We only have values for FY20 and that's why we lookup for that specifically but elsewhere it should bring in values based on what that line has.

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…