Level 3 TAR03 Country Account Calculation- is my Factor logic and values correct? Please help

kbrahmamdam · 2024-04-19T17:55:29+00:00

There was an error rendering this rich post.

I've been stuck on this part for some time now. I have followed the instructions carefully and when I calculate the Factor line item in TAR03 I am getting negative values.

I did a SUM by Country on the Target line item in TAR03.

Are these negative values correct or is something wrong in my TAR02 line items?

I'm also not sure what the check line item is for.

Accepted answers

All comments

SriNitya

AKPlans123
Formula is factor is wrong.
From TR02 Module fetch data into Targets, To Change, Held or Revised by using sum with country, then update the formula in Factor.
Check line item is Final Target Sales

kbrahmamdam

Hi @SriNitya thanks for the help. I made the changes you said and I have different numbers now. I will post a screenshot can you tell me if these look correct?

Now do I take this Factor line item from TAR03 and multiply it by the Final Sales Target line item in TAR02?

It should be 0.936 for Italy but I am getting 0.8.

SriNitya

AKPlans123 Hi
Check your logics in To Change, Held or Revised data seems to incorrect so you are getting 0.8.

binenoy893

@ Tower Defense I'm not really sure about this calculation!

unknown

This content has been removed.

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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