How to Calculate Forecast period revenue in proportion of actual sales of CY

Options
ami17
ami17 Member, ALL USERS Posts: 1 New Contributor
in Planning & Modeling

ami17_0-1661950642729.png

 

Tagged:

Comments

  • JJANIK
    JJANIK Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor

    Hi, I belive you will need an intermediary line item with percentage calculation that you will use to multiply the forecast value by. So:

    1. Create a Proportion Ratio by dividing country to the Total: Actual Sales/ Actual Sales Total (depending how you setup the list)

    2. Refer the total forecast value in formula to multiply by the ratio.

     

     

Categories