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

Time hierarchy filter new ux when brought forward option is turned on?
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-
Docusign Integration
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
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…