TR02

CommunityMember111277
CommunityMember111277
in Modeling

Hi All,

 

Need your advise. I have created the TR02 module using an unorthodox process to ensure that the final sales target matches with the initial sales target(Parent level) taking into account of Overrides & Hold. BUT, details at the country's line item level is not matching with 8.4 Check Your Build. 

 

Have I missed any mistake? 

 

CommunityMember111277_2-1596292506613.png

 

 

CommunityMember111277_0-1596292275644.pngCommunityMember111277_1-1596292326320.png

 

Thanks

AB

Tagged:

Answers

  • prabhu
    prabhu

    Hi @CommunityMember111277,

     

    You need to check your Final Sales Targets Formula.

     

    Check the example 8.2.5, This example will give you an idea (order which you have to follow in IF ELSE statement).

     

    Work on Example 8.2. using paper and pen and get the logic correctly.

     

    Your redistribution factor is different form the example.

     

     

    All the best.

    Thanks,

  • CommunityMember111277
    CommunityMember111277

    Yes, I was calculating the redistribution % as a whole & not country wise. Corrected the logic now & its working. Thanks.

Categories