Section 13 : Sub-Region Quota - Activity check clarification

Hello All, I have completed building the Activity #18 – Sub-region Quota Module and the numbers are not matching for the Activity check. You will notice that the number are not populating for Rep Quota Rollup and Sub-region Quota between Jan 15th and Sep 15th ( I am not sure if the other numbers that are show are correct.) The 2rd screen shot has the formulas. The 3rd screen shot is from the module Rep Quota, which actuall is the cause of this problem. The 4th screen shot has the formulas for the Rep Quota module. Hope I attached all the pertinent information, Would really appreciate comments on what corrections that I should make. Thanks, Anjum

Accepted answers

All comments

harish_bk

Hi Anjum

This would be very tough to answer and only those who are currently doing the course should be able to answer,

could you please share the view at a rep level than at a region level so that we could see the results of all values,

Further am not sure if your headcount formula is logical as you are trying to define it on quota please check that (I might be wrong as I have no idea on the purpose of the module.

PrevContributor

Hello Harish,

Thanks for your reply. I did look up this issues and found a thread where it was recommended to removed the switchover date from Version.
The Issue with the Rep Quota modue as the data for the line items Region and Role are not populating.I did send out an email to the enablers, Hope to get their reply soon and I will post their comments.

Your are correct on the headcount formula : IF Active? = TRUE THEN 1 ELSE 0, i had selected the wrong line item.

Thanks,
Anjum

harish_bk

Hi Anjum

For Region and Role do a F8 in the results cell and see the details they might help.

Further check if you have updated all the properties and hierarchies correctly in the Region list as required for the training.

PrevContributor

Hi Harish,

I had writted to the Enablers and they came back with the solution that some of the students are having similar problmes and the issue is with the VERSION, so they asked me to remove the Switchover date and re-load all the data.
I will update the results once done.

Appreciate your comments.

Many Thanks,
Anjum

Quick Links

Can you help?

Unanswered questions

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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385