2.3.9.3 Update Historic Volumes for Baseline Forecast

imadlou

Hello everyone,

I encounter a problem concerning the formula of "Offset Volumes for 1st Forecast Year" . I wrote the formula that seems logical to me but it doesn't work. Can someone help me correcting it ? Thanks in advance.

N.B : The first image represents hints for the formula and the second image is the formula that i wrote.

cap1.PNG

cap2.PNG

Dikshant

@imadlou,

You just missed a small thing; instead of 52, make it -52.

Formulla: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0

Negative means you want to fetch values from past

Position means you want to fetch value from future

imadlou

@Dikshant

Thank you for your response and time. Have a great day !

VIVIANMO

hello, I have the error in the formular. Could someone help me

Dikshant

@VIVIANMO,

Please read the error. Your model does not have the 1st Forecast Year line item, or it has a slightly different name. Go to SYS01 module and refer instead copying it from here.

AlexandreRiveaux

Hello, i have a similar issue for this one, i entered what should be the correct formula but it doesnt work.

Thanks for your help

UDAYSAI

Hi @Dikshant

I’m working on Activity 2.3.9.3 Update Historic Volumes for Baseline Forecast 

I’ve entered this formula, but I’m seeing zeros in the activity results.

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0

Can anyone help me troubleshoot this issue? Are there any common reasons why ?

Thanks in advance for your assistance!