I am trying FORECAST for the first time. It works fine when my only by field is numeric or a date but when I add my division code (aplha) as the first BY field I get a formatting error. And yes I realize FORECAST needs the last BY field to be numeric or a date. But why does it care if the first one of two is alpha?

This message has been edited. Last edited by: Kerry,

What version are you on ?

The examples in the documentation have a first sort of alpha.

Does it work or fail ?

Calculating Trends and Predicting Values With FORECAST

I'm on 767. And yes, I saw the help text which made me think it should work but it doesn't. I've tried a combination of things and still no luck. Any help would be greatly appreciated

The sample in the documentation works for me on 7.1.6, 7.6.6 and 7.6.9.

Can you repro on one of the samples files, adn post the code ?

I will try. In the mean time can I see the code the exapmle produced. It doesn't show that in the example nad maybe that will give me a clue as to where I'm off.

This is closed. Thanks