User selected version comparison

Options
bruce_cavella
bruce_cavella Member, ALL USERS, GroupMember, Community Member, Community Pioneer Posts: 2 Master Anaplanner of the Year

Hi, I have a module in which variance calculations are executed on 2 static versions. However, I'd like to set up a variance module in which the user can select two versions from a list of versions to be used in the calculation. I've set up a 'Budget Selector' module with 2 line items (Budget #1 & Budget #2) and have tried multiple configurations - Boolean, text, list formatted - but I can't seem to get the Version name into a SELECT statement to retrieve the proper data. As an example, I've tried this: 'Raw Data'.Amount[SELECT: VERSIONS.Budget Selector.'Budget #1'], but no luck. Any suggestions? Thanks, Bruce  

Comments

  • bruce_cavella
    bruce_cavella Member, ALL USERS, GroupMember, Community Member, Community Pioneer Posts: 2 Master Anaplanner of the Year
    Peter,

    Thanks for the help. Solution #1 works, but is is long and will need to be maintained. 

    Bruce