Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a set analysis expression:
time( fractile( {<[Year]={$(=Max([Year]))}, [ColA]={`n/a`}>} [ColB], 0.5), `hh:mm`)
This works when I'm using it in a table and returns as expected
When I try to place this in my Load script, inside of a variable:
set vTest = 'time( fractile( {<[Year]={$(=Max([Year]))}, [ColA]={`n/a`}>} [ColB], 0.5), `hh:mm`)';
n.b. I have replaced ' with ` to keep the string playing nice.
Replacing my original expression in my table now returns NULL, not the value as expected.
I have found it is this part of the expression ($(=Max([Year]))) which isn't happy living inside of the variable, could anyone help or advise why this would be?
Thanks
James.
Engine sees $ and tries to calculate. Try to wrap your extension into replace function - examples: Stop Dollar Sign Expansion in the script (Escape Character ??? )
Engine sees $ and tries to calculate. Try to wrap your extension into replace function - examples: Stop Dollar Sign Expansion in the script (Escape Character ??? )
Oh dear, I did this as a dirty workaround and it's gonna be a pig! Thanks anyway I'll add another workaround for this replace nonsense and hopefully I'll be there.
Cheers for the quick response, enjoy your day.