Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Create your variable for X and Y. Let's call it vTest. Then your formula will be something like this:
=Min($(='[First Year '&'$(vTest)'&']'))
Create your variable for X and Y. Let's call it vTest. Then your formula will be something like this:
=Min($(='[First Year '&'$(vTest)'&']'))