Use variable within brackets in an expression

[mahmad]

Hello,

I'm trying to figure out how to dynamically change text within brackets (variable name within an expression). I have a variable that a user can determine with a dropdown, and this can be either X or Y. I would like to use this value to populate the expressions below:

Aggr(Min({$<[Year] = >}[First Year X]),[%ID])

Aggr(Min({$<[Year] = >}[First Year Y]),[%ID])

I would like to replace X or Y with a variable, but am not sure about the syntax; something like "[First Year " & variable & "]" would be great.

Thanks!

[_ylc · Accepted solution]

Create your variable for X and Y. Let's call it vTest. Then your formula will be something like this:

=Min($(='[First Year '&'$(vTest)'&']'))

[mahmad]

This worked beautifully - thanks!