Calculating final sales forecast

CommunityMember111277
CommunityMember111277
in Modeling

Hi,

 

In order to calculate the final sales forecast, I have used a very unorthodox process (attached below). Now, even though the overall amount at the Account parent level is matching, however there are some mismatch with individual account line level (mismatch between my module & what is there in the Sprint 1 screenshot)

 

Can anyone confirm weather my process is incorrect or not? If not, then can anyone confirm the correct approach

 

CommunityMember111277_0-1596213336337.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,

Categories