Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want my variable, vPop, to look like this:
SUM({$<Year={$(=MAX(Year))}>}Population)
Notice the part in bold.
See in attached ; open the variable view
Can I do this in SET or LET in the Load Script
When I try this:
SET vPop = SUM({$<Year={$(=MAX(Year))}>}Population);
After reloading, the value of vPop is this:
SUM({$<Year={}>}Population)
And therefore $(vPop) evaluates to 0
I managed to do it by separating "$" from the "(" and concatenating them together -- but it's ugly.
Oooh, another clever suggestion, I didn't think of that.
I really like it because I can
But you said:
Doing so, you can use dollar sign expansions etc. in your excel columns with the need for a special treatment
Did you mean:
without the need for special treatment
Yes!