Ability to use Concatenate (&) in a Select Function

Options
VickiToy
VickiToy Member, ALL USERS, Partner Posts: 1 Occasional Contributor
in Planning & Modeling

I would like the ability to add an Concatenate to Select Function.   For example SELECT: VERSIONS."Budget "&NAME(Current Year).  As we have multiple Budget Version, the current version in play and the future version.  So in our variance reporting module it would select the correct version as budget.  Similar with forecast … "Forecast "&NAME(Current Quarter).     Currently,  it seems that we will have to update the formula each time it changes.  

Tagged:

Categories