Hi All,
I am facing a challenge while replicating the Actual selection to Forecast.
Can we have a formula where forecast will take the same Boolean selection as actual.
In the Column are versions(Not list).
@Gpatwa
You are on the right way!
I see you already put formula scope to the line item. Good job! Now you only have to enter a formula to pick the value from Actual version of the same line item. Hold Product[SELECT:VERSIONS.Actual]
By the way I am very curious what "All Version" does? Did you apply some formula in Versions tab?
Hi @KirillKuznetsov,
Thank you for the solution.
here the All versions stand for Actual + Forecast 😀
@GpatwaDo you actually have a formula wich sums the two versions together?
If yes then I would recommend you to read Planual article about this: https://community.anaplan.com/t5/Chapter-1/1-02-02-Do-not-use-formulas-in-the-version-settings/ta-p/71167
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
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.…