I am investigating for a long time to find the formula to calculate the Quarterly Initial Sales Target.
According the user story ,
I checked all my data and
according your screenshot for Nutzo bar I must find 670.8
Using my values I cannot obtain this figure for US, Nutzo Bar/Candyate (family Chocolate) and in Q1.
The detail of my calcul is :
Quaterly Initial Sales Target = Initial Country Sales Target * (PY Product Sales Revenue/PY Country and Product Family Sales)
For US /Nutzo Bar/Family Chocolate in Q1
Quaterly Initial Sales Target =635477* 589,66/290787 = 1289 and it is different with the value of 670,8 giving in the User story.
So could you please give me hints and advice to have a the same data comparing with the US ?
Many thanks for your help.
Here is an export of my module TAR01 Detail Sales Target
PY Country and Product Family Sales Numbers are not looking right, although the formula looks ok to me which means your numbers in TAR01 Sales Target Module are incorrect.
Hint: Your Numbers should be 537,863 for US/Chocolate/Q1FY20 intersection in TAR01 module
Hope that helps
Sorry but my case is not resolved.
It seems that my PY Revenu Country and Family is wrong.
I checked my data Actual PY and the values are correct according your file A actual.
All my formula are correct with LOOKUP and SUM fonctions.
So could you please give me hints to obtain the good figure ?
In my exemple : I would like to obtain 558647 for Nuzco / Chocolate/US Q1
to calculate the Quatery Initial Target Sales
Could you please confirm the PY Revenu Country and Family Product ?
Perhaps the computed figure must have a ponderation coefficient.
i.e : 589,7 * 635477/558647 = 670,8 FOR Nuzco Bar
I really don't know how can I obtain 558647 ? I founded 290787 !
So I don't understand why ?
See my screenshot below :
Thanks for your help and for reply.