2.3.9 Activity: Historic Volumes to Baseline Forecast

Markcol
Markcol
in Academy and learning discussions

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

Tagged:

Comments

  • TinaL
    TinaL

    Hi,

     

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

  • RavinderB
    RavinderB

    @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

Categories