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

Average wait time for Workspace Access - January 2026
Hello, I submitted my application for the Talent Builder Program after completing "The Anaplan Way," but I haven't received my workspace credentials yet. Has anyone who applied in the last two weeks received their access yet?
Management Report allows for dynamic filtering, but columns don't dynamically change
It's now possible to use the additional insights to have dynamic filters, however the columns in the table are fixed widths. It's quite unfortunate that the ability is added, but the layout isn't dynamic. I understand that a report is more fixed, but adding dynamic columns would really help make the management report…
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.