Page **1** of **1**

### How to code for putting average MAE from rolling forecast into table

Posted: **Sun Dec 16, 2018 4:07 am**

by **chairake**

Hi,

I have problem to put average MAE from rolling forecast into table

because of type of scalar, matrix and string problem.

I would like to know how to code them.

Help me please

### Re: How to code for putting average MAE from rolling forecast into table

Posted: **Sun Dec 16, 2018 4:03 pm**

by **EViews Gareth**

Easiest way for you is probably to just add the numbers and divide (i.e. calculate the mean manually).

### Re: How to code for putting average MAE from rolling forecast into table

Posted: **Sun Dec 16, 2018 10:46 pm**

by **chairake**

Thank you for your reply EViews Gareth but I have ever try

the way as your recommend.

by @sum(.......)/7

zresult_{%n}(10,2) = @sum(@mae({%n}_r{!m}f,{%n}))/7

but the program tell the error that

Scalar sent to function which operates on a matrix in

"ZRESULT_{%N}(10,2) = @SUM(@MAE(BMIX_E_R1F,BMIX_E))/7".

Because i don't understand truly about type of object and how to manage them.

How can I solve the problem.

### Re: How to code for putting average MAE from rolling forecast into table

Posted: **Sun Dec 16, 2018 11:14 pm**

by **EViews Gareth**

Just use + rather than a function.