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

Tags

Modeling

Calculation Functions

Accepted answers

All comments

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

Import Final Demand Forecast into DATA02 Module - Would like to have your suggestions on this.
Not sure the way i handled this scenario right or wrong, would like to have your thoughts on this .. Since the Supply chain model, dem03 final demand forecast dimensioned by Accounts, Product SKU's. However, my assumption is FP&A, No way related to accounts(we didn't added any lists for account during the FP&A model…
ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…