LET vName = '=Num(Sum({<Type ={'A'}, Year = {$(=Max(Year))}>} Sales,'#,##0.0')';
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
To "escape" the single quote sign, use another one in front, so in your expression:
LET vName = 'Num(Sum({<Type ={''A''}, Year = {$(=Max(Year))}>} Sales,''#,##0.0'')';
But using LET evaluates the expression on the right of the "=" before assigning the value to the variable, and since it is valid syntax, the part $(=Max(Year)) will be evaluated. It does not have any value during the script, so the result in the variable overview after the load will be
Num(Sum({<Type ={'A'}, Year = {}>} Sales,'#,##0.0')
I would use SET instead of LET and use Chr() function as mentioned above by A.M.
I am loading 130 variables and changing quotes by chr(39) is time consuming so i tried to add one more quote front and tried to add front and back as well but no luck.
I can only suggest you to use some text editor with Find and Replace and copy back to the script.
It likely didn't work because of the reason mentioned above, the set analysis, actually any expression in the form $() or $(=) will be evaluated prior to be assigned. During the script, most of these values are non existing, so the $() is expanded into null or garbage.
No worries about nulls because i will store those into variables. I am thinking about your first suggestion ""escape the single quote sign, use another one in front", is it possible?
Yes it is, use the example I wrote above. But the issue with the expressions will persist: as soon as the script finds a $() or $(=) the contents between the brackets will be evaluated and the expression will not be kept.
.png "Miguel_Angel_Baeyens"){kind=avatar}
