Set Analysis in variable

[wallerjc]

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.

[tomasz_tru · Accepted solution]

Engine sees $ and tries to calculate. Try to wrap your extension into replace function - examples: Stop Dollar Sign Expansion in the script (Escape Character ??? )

[wallerjc]

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.