How to use collect function on a particular version?

Highlighted
Previous Contributor

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

2 REPLIES 2
Highlighted
Regular Contributor

RE: How to use collect function on a particular version?

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]
Highlighted
Regular Contributor

RE: How to use collect function on a particular version?

Hi Pravar, Did my suggestion work? Pete