Formula or Function to calculate a trend from historical data

Hello,

I am currently trying to calculate a future trend based on actual historical data and was wondering if someone knows of a function or formula within Anaplan that works best for this?

Thank you

Accepted answers

All comments

ArunManickam

You could calculate a simple average based on x months/weeks using TIMESUM function.

For more sophisticated models, use the statistical model app.

https://community.anaplan.com/t5/Best-Practices/Statistical-Forecasting/ta-p/40359

Thanks

Arun

Quick Links

Can you help?

Unanswered questions

Daily Date Format
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
1.5.2 activity: import data into beginning inventory
Kindly assist me to load data into the model.
Support error
Hello , Facing an error in looging in support portal , can anyone assist