About titiboys

Hi Chris,   I cannot upload my certificate level 3 after completed your Docusign document. So what is happenning on my connection ? Many thanks for your help. BR Thierry   N.B : It is very important for me to receive the certification (new projets with new customer) ... View more

I Jared   Many thanks for thé reply. I will try next week after my vacations. Best Regards Thierry   ... View more

Hi Jared,   Thanks you very much for the tips.   Unfortunately the figure (PY Country and PF)  is not correct  for me.   Step 1 : I imported Revenue for PY in Data02 with the formula : Revenu from previous Year[LOOKUP: 'SYS00 Time Settings'.PY Qtr] And according the story the values are correct. See the the screenshot   Step 2 : I calculated the PY with sum fonction in the module TAR 02 Sales Target with the formula :  'DAT02 PY Revenue to CY'.Actual revenu[SUM: 'SYS03 Account>Product Details'.'G2 Country', SUM: 'SYS03 Account>Product Details'.'P1 Product Family'] See the screenshot below:   Step 3 : I calculated in the TAR 01 detailled sales target the PY Revenue by Country and PF with  lookup fonction 'TAR01 Sales Target'.PY Revenue Good [ LOOKUP: 'SYS03 Account>Product Details'.'P1 Product Family' , LOOKUP: 'SYS03 Account>Product Details'.'G2 Country' ] See the screen below :   So I don't understand why I can't get the right figures for PY Country and PF. Thank you very much for your help.   You understand I spend a lot of time analyzing the problem.   Thanks for reply. Best Regards. Thierry               ... View more

Hi ,   Thanks for your answer. But are you  using the same file  to import Baseline Financial forecast  ! According to me the Base line for Chocolate/US/Q1 is 605 216 not  537,863      So what can I do to obtain the right figures !. Thanks for reply Thierry           ... View more

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         ... View more