Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How do i calculate simple Forecast??
Supply any example you can as the simplest.
Please help out.
Regards:
Thabiso
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?
ps Unfortunately you cannot get at some of the trendline formula as functions which is a bit of a shame (only LINEST)
Hi,
i have no idea on how to start please supply a simple Forecast on a straight table?
Thanks.
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)