Forecast

[tracycrown]

Dear all

I have problem in writing script to forecast the sales volume, please help urgently.

The correct answer is computed and shown in the worksheet.

Thank you

Tracy

[jaibau1993 · Accepted solution]

Hi!

Please, try the following expresion:

if(RowNo()=1,
//if first row then the value of thge first column
	Column(1)
,
//else, formula provided
	Above(Column(1))*0.3+Above(Column(2))*0.7
)

or, if you prefer, find the attached QV file.

Bests,

Jaime.

[tracycrown]

Dear Jaibau1993

The answer is correct, you are very clever.

Many Thanks

Tracy