2.3.9 Activity: Historic Volumes to Baseline Forecast

Markcol
Frequent Contributor

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
TinaL
Occasional Contributor

Hi,

 

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

View solution in original post

RavinderB
Regular Contributor

@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

View solution in original post

2 REPLIES 2
TinaL
Occasional Contributor

Hi,

 

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

RavinderB
Regular Contributor

@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