How to use collect function on a particular version?

Hi, I am trying to use Collect() function to collect a value on a particular version by using Line Item Subset ,but it is only collecting a value from only one version to other versions. Please suggest . Thanks in advance ....

Collect_Function_887.jpg

Accepted answers

All comments

peter_mcanena

You need to do this in two steps. First, collect into a line item that's fully versioned (Versions = All, Formula Scope = All Versions). Let's call this line item Collect All Versions:

COLLECT()

Next, use an unversioned line item (Versions = Not Applicable, Formula Scope = All Versions) to pick the version you want:

Collect All Versions[SELECT: VERSIONS.Actual]

peter_mcanena

Hi Pravar,

Did my suggestion work?

Pete

Quick Links

Can you help?

Unanswered questions

Forecaster Explainability Results Clarification
We transitioned from PlanIQ to Forecaster and started importing explainability results into the model. But I’m struggling to interpret some of the since there is no information in Anapedia. Here are examples from the sales explainability results list: Historical: trend (ETS, ENSEMBLE) Historical: linear_trend (ENSEMBLE,…
ADO connection problem with “Google Cloud Storage”
I’m having a problem connecting to “Google Cloud Storage” with Anaplan Data Orchestrator. The GSP Service Account Email is correct and the GCP Private Key is correct, but it will not accept the bucket name. Please provide some guidance. Thanks.
undefined_onFileChange
I get the undefined_onFileChange error on uploads. I get the error on every item I try to upload(Lists, Modules) I have tried the following: Refreshed Browser Cleared Caches Changed browsers Restarted machine Redefining the file Recreating the file Changing the file type I probably tried some other things also. Anything…