Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,'@','$');
Don't use quotes around the expression:
SET TotalPrintMail = num (count({$<$(vSet), member_Communication_Print_possible={'Yes'}>} Total <$(vTotal)> distinct %x_membermember_ID),'#.##0','.');
SET TotalPrintMail = num(count({@<(=@(vSet)), member_Communication_Print_possible={'Yes'}>} Total <(=@(vTotal))> distinct %x_membermember_ID),'#.##0','.');
LET TotalPrintMail1 = Replace(TotalPrintMail,'@','$');
Do like this:
SET var1= '{$<'&'COUNTRY={"Brazil"}>}';
Don't use quotes around the expression:
SET TotalPrintMail = num (count({$<$(vSet), member_Communication_Print_possible={'Yes'}>} Total <$(vTotal)> distinct %x_membermember_ID),'#.##0','.');
thanks, it seems that was the problem