Variable with set analysis in script

[felcar2013]

hi

i have this formula in a chart expression and as i have many of them, i want to create all of them in the script, but i got some problems. The script runs well but i do not get the data in my chart. See please below,

thanks

Expression in Chart

num (count({$<$(vSet), member_Communication_Print_possible={'Yes'}>} Total <$(vTotal)> distinct %x_membermember_ID),'#.##0','.')

Variable in script:

SET TotalPrintMail = 'num(count({@<(=@(vSet)), member_Communication_Print_possible={'Yes'}>} Total <(=@(vTotal))> distinct %x_membermember_ID),'#.##0','.')';

LET TotalPrintMail = Replace(TotalPrintMail,'@','$');

[#2]

SET TotalPrintMail = num(count({@<(=@(vSet)), member_Communication_Print_possible={'Yes'}>} Total <(=@(vTotal))> distinct %x_membermember_ID),'#.##0','.');

LET TotalPrintMail1 = Replace(TotalPrintMail,'@','$');

[#3]

Do like this:

SET var1=  '{$<'&'COUNTRY={"Brazil"}>}';

[Gysbert_Wassenaar · Accepted solution]

Don't use quotes around the expression:

SET TotalPrintMail = num (count({$<$(vSet), member_Communication_Print_possible={'Yes'}>} Total <$(vTotal)> distinct %x_membermember_ID),'#.##0','.');

[felcar2013]

thanks, it seems that was the problem