About titiboys

titiboys

Hi Academy, 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. Best Regards. Thierry

titiboys

Hi community, 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 Many thanks for your help. Best Regards. Thierry

About titiboys

Re: Level 3 calculate the Quaterly Initial Sales ...

Level 3 calculate the Quaterly Initial Sales Targ...