TAR01 Detailed Sales Target Level 3 Model Building

Hi,

I have a question on the LI "Initial Country Sales Targets" in Module TAR01 Detailed Sales Target. For this line item I'm assuming that we are pulling from the TAR01 Sales Targets where the initial country sales targets are calculated. Would I then use my SYS03 Module to SUM by Country and Product? Below is a screen shot of my LI and current formula.

Thank you

Accepted answers

ManjunathKN

Hi

In the detailed sales target, after you refer from tar01 module you need to lookup on p1 product family and g2 country from your sys03 module.

Hint: sum is used when you are having one to many relation.

Thanks,
Manjunath

All comments

ManjunathKN

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…