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
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
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…
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.…
