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

ami17
ami17
in Modeling

ami17_0-1661950642729.png

 

Tagged:

Answers

  • JJANIK
    JJANIK

    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