I have i problem. The variable works in the dashboard but not in the script. It looks like it cuts of my ' in the end, why?
Dashboard Script(and works):
Try it with:
set = "YourExpressionIncludingSomeSingleQuotes";
The script runs without error, but the variable dashboard is blank..
Hi Sebastian, it's as Marcus said. Please have a look to this:
LET and SET
That may clarify the difference in using SET and LET
Hope it helps,
You can try
let vPackCare='if(len(RavaraNr)=5 and Left(RavaraNr,1)=3,sum(levAntalRavara)/ArtikelVikt),'& chr(39)& chr(39)&')';
To represent a quote within the string, code the single quote twice. So a pair of single quotes would be coded as.
LET v1 = 'if(x,y,'''')';
Thanks works now!
Retrieving data ...