Hello,

I was following the instruction from WF docs and
built procedure calculating the FORECAST using MOVING AVEREGE method.
The code is below:

   
DEFINE FILE CENTORD
PERIOD/I2 = MONTH;
END
TABLE FILE CENTORD
SUM
     CENTORD.STOSEG.REGION
     CENTORD.PINFO.QUANTITY
     CENTORD.INVSEG.LINE_COGS
BY  PERIOD
WHERE CENTORD.STOSEG.REGION EQ 'WEST';

ON PERIOD
RECAP MOVING_AVG/D12.2 = FORECAST(LINE_COGS, 1, 3, 'MOVAVE', 3);

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END
-EXIT

The result of first 2 occurrences I've got is different compare to result from WF docs.
Outputfrom procedure:

MOVING_AVG:
1. 3829915.21
2. 6955250.36

In WF docs:
1. 4,775,124.00
2. 8,830,683.00

The rest of values are the same .
Please help me to understand the issue.

Thanks.

This message has been edited. Last edited by: Y&Y,

Hi All,

I found the way to get correct values after
applying FORECAST function....
But I do not see the explanation for that:
Removing the style from the code will bring correct generated Moving Averages.
If anyone can point me to get the explanation for that- it's very appreciated.

Thank you.

To be more specific it appears to be all of the "border-*" syntax that is the cause but I can't explain why!! as it should have not have any impact upon the report at all?

Both in App studio and Dev Studio.

T

Thank you Tony.

I've tested all methods in a FORECAST,
and all of them behaved same way:
generated wrong numbers when style is in the code
and correct - without style.

I was using just Dev Studio