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


  • 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:
    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]
  • Hi Pravar,

    Did my suggestion work?