Request for Hints on Level 3 Q2 and Q3

Hi all,

I hope you're doing well.

I’m looking for some hints regarding Level 3 Q2 and Q3. I tried re-importing the data provided in the files, but for some reason, I can’t retrieve the Amount Increased or the Initial Country Sales Target for Chocolates/US.

Could anyone provide a hint on what I might be doing wrong? The fact that I got Question 1 correct makes this even more puzzling, as it suggests that I imported the data correctly. Since Questions 1, 2, and 3 are linked, I’m wondering if I might be missing something subtle.

Could this issue be related to rounding, or is there something else I should check?

I’d greatly appreciate any advice or guidance.

Thanks,
Pat

Accepted answers

All comments

Dikshant

Are you still giving the exam?

If I understand it correctly, you've uploaded the data provided before the exam. Got the correct answer for Q1, but stuck at Q2 & Q3.

This is what I see in one of the models. Not sure if this helps… Can you mention what data you've uploaded, so that we can try to understand which upload might have gone wrong?

Patrykallaboutfood

Hi Dikshant,

I followed the Model Exam Preparation Activities and imported the data into both the Data Hub model and the Sales Planning model, as instructed.
My data was correct for the "Check Your Build: Italy Example" in Sprint 1 of Level 3. Since I got question 1 right, I’m confident I uploaded my 2019 actuals correctly.

The above is my data for PY Revenue copied from Data Hub model (A 2019 Actuals).

The total for all products is 25,355,925.

I checked my mapping for Territory to Accounts and it looks all good.

I would be grateful if you could provide some hints.

Thanks,

Patryk

OllyBe

@P a t r y k a l l a b o u t f o o d
I followed the Model Exam Preparation Activities and imported the data into both the Data Hub model and the Sales Planning model, as instructed.
My data was correct for the "Check Your Build: Italy Example" in Sprint 1 of Level 3. Since I got question 1 right, I’m confident I uploaded my 2019 actuals correctly.

Did you solve that finally?

Patrykallaboutfood

@OllyBe

No, I did not. I’m still waiting for some tips. I’m unable to figure out what went wrong.

Patrykallaboutfood

I get the same answer when I do the calculation in Excel:

Patrykallaboutfood

@OllyBe @Dikshant any updates on that?

Quick Links

Can you help?

Unanswered questions

how to SUM by native users, sku & time dimension all together?
I want to do a SUM from the source module which has native users, SKU list and time dimension to a target module line item by all users by SKUs. Target module only has a subset of the SKU list and nothing else. Need some inputs on how to build the mapping for the SUM. Is it also possible with the Anaplan native users list…
Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
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.…