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
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
Multi-Cell Selection for Calculation Summary When selecting two or more cells in Anaplan, a calculation menu appears in the bottom-right corner displaying useful statistics such as Count, Min, Max, Average, and Sum. This is a helpful functionality for quickly analyzing selected values. However, the current functionality is…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
