2.3.9 Activity: Historic Volumes to Baseline Forecast

Hi,

Some values should be in 'Offset Volumes for 1st Forecast Year' line, but nothing!

Where am I doing wrong?

 

Markcol_0-1656607596175.png

Thanks,

Mark

Comments

  • Hi,

     

    The OFFSET function is working with the -52 Volumes. So if you go to FY20 you will see your results.

  • @Markcol The IF formula you are using refers to the 1st forceast year, which in this case is FY20; if you scroll across to this time period you will see the data. 

    Thank You