How do i calculate Forecast

[#1]

Hi All,

How do i calculate simple Forecast??

Supply any example you can as the simplest.

Please help out.

Regards:

Thabiso

[john_s_w_wood]

Hi Thabiso

Do you mean to use the built in trend lines on the Expressions tab of charts? There are also some basic statistical functions which may help e.g. LINEST* functions.

otherwise you may need to perform a statistical calculation as you load the main data (if you do not have a forecast data set somewhere to load along side)

Can you expand on your requirement please?

[john_s_w_wood]

ps Unfortunately you cannot get at some of the trendline formula as functions which is a bit of a shame (only LINEST)

[#4]

Hi,

i have no idea on how to start please supply a simple Forecast on a straight table?

Thanks.

[#5]

Hi,

Below is what i used to get Forecast, but it hides one of my Columns it makes it Null but with an answer on a Sum Expression

Sum( { <Year =, Month ={">=$(='201209') <=$(=max(Month))"}>} Records)