How to use collect function on a particular version?

[PrevContributor]

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

[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