Level 3 Sprint 1 3.3 Check your Build

\\Hi,

I am struck with Level 3 Sprint 1 activity. As per the screenshot it refers to TAR01 Sales target module. However in the downloaded version, has different dimension and does match with the screen shot.

@Dikshant Can you please help?

So I created another module TAR 04 with line items mentioned in 3.3 Check your build snap. I am confused what formula to use to get % Increase and Amount increased.

Any help these will be appreciated? Where Am I going wrong?

Accepted answers

Deekshitha29

All comments

Dikshant

@Deekshitha29 - Let me explain the calculations for your understanding.

Baseline Final Forecast: This data you've already loaded in one of your DATA modules, I guess DAT03.

% Increase: This you've already entered in Percentage Increase module.

Amount Increased is nothing but % Increase * Baseline Financial Forecast

Initial Country Sales Target is Baseline Final Forecast + Amount Increased

Deekshitha29

@Dikshant Thanks for the quick response. I am still confused, in Level 3 Sprint 1 we don't have DATA Modules yet. Are we supposed to create them?

Dikshant

You must have done an activity where you needed to load the baseline forecast into a DATA module before this activity? Where have you loaded that ?

Deekshitha29

@Dikshant I have loaded directly into TAR

there was no mention of creating DATA Module in the activity.

Deekshitha29

Here is the screenshot

Dikshant

You are checking for US, but the example is for Italy. Please check for Italy numbers will match.

Ideally, you should load it into DATA module since Forecast is monthly but it's fine.

Check and let me know.

Deekshitha29

@Dikshant though the Baseline forecast is showing up. The % increase is showing 105% in the snapshot whereas we have to input has 5% as per the activity instruction. My confusion is that are we suppose create another module just for the percentage then use a formula to bring it into TAR04?

Activity snapshot

Dikshant

Can you show your formula for % increase line item ?

Ideally, it has to be 1 + Percent Increase.Percent Increase.

So if a country needs to grow by 5% it means it it's 105% of its baseline forecast. Try it out!

Deekshitha29

@Dikshant I tried using the same formula. but the results are not matching. Are suppose to use in lookup in it?

Deekshitha29

@Dikshant I think i figured it out. Problem was with the Percentage increased. I had to plug in the % by month, instead i had them by year. So I had to change them by month, and I changed the summary to Min to capture for year. It seems to be working. It is now matching with the snapshot. Not sure if it is the right method though.

Thanks for helping out. I really appreciate it :)

Dikshant

Percentage Increase module needs to have year not months

Deekshitha29

Correct.. I changed it to Month. It worked now. Thank you @Dikshant

Deekshitha29

Quick Links

Can you help?

Unanswered questions

Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…