Hi, the quick solution is to use replace to omit using characters like $ or ', to avoid to interpret them and just load the string, like:
LET vFinalOutput = Replace(Replace('Sum({<[DateMonth] = {|#(=#(vMaxYear))|}>}Record)','#','$'),'|',Chr(39));
So | will load as ' and # will load as $.
Another most common solution is using an external file to load variables with values assigned, loading from excel file also avoid the interpretation of $( or '.
Hi, the quick solution is to use replace to omit using characters like $ or ', to avoid to interpret them and just load the string, like:
LET vFinalOutput = Replace(Replace('Sum({<[DateMonth] = {|#(=#(vMaxYear))|}>}Record)','#','$'),'|',Chr(39));
So | will load as ' and # will load as $.
Another most common solution is using an external file to load variables with values assigned, loading from excel file also avoid the interpretation of $( or '.
