nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Forecast to get value from Actual version

Gpatwa

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).

Accepted answers

KirillKuznetsov

@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]

All comments

KirillKuznetsov

@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]

KirillKuznetsov

@Gpatwa

By the way I am very curious what "All Version" does? Did you apply some formula in Versions tab?

Gpatwa

Hi @KirillKuznetsov,

Thank you for the solution.

here the All versions stand for Actual + Forecast 😀

KirillKuznetsov

@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

Quick Links

Can you help?

Unanswered questions

Near-Real-Time Anaplan → Claude MCP: Any Faster Than Bulk Export + MySQL?
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
Anaplan AI Actions
The July and August releases added several useful capabilities to Anaplan AI, including the ability to create and retrieve saved views and create list import actions. It would be valuable to extend these capabilities to support the full end-to-end user story: creating a saved view and using it as the source for an import…
Anaplan Analyst performance on large, sparse models
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.