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

Moving Sum for Formula driven number format line items
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
Docusign Integration
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…