Set Analysis Expression not Working

[#1]

Hi All,

I'm trying to create a Set Analysis expression in the edit script using a variable as shown below:

SET vRevenue = "Sum({$<FiscalYear = {$(=max(FiscalYear))} >}Revenue)";

When i access the vRevenue variable  in the chart,i'm getting an internal error as shown below:

Sum({$<FiscalYear = {'(internal error)'} >}Revenue)

The same is working fine when i create a variable in the variable overview and i want to create it in the edit script. Please suggest that how to overcome this error.

Thanks in Advance.

Regards,

Desmortes.

[Sokkorn]

Hi Desmortes,

Did you try this yet: =$(vRevenue)

Regards,

Sokkorn

[Gysbert_Wassenaar]

Try: LET vRevenue = 'Sum({$<FiscalYear = {$' & '(=max(FiscalYear))} >}Revenue)';

Or this:

SET vRevenue = Sum({$<FiscalYear = {@(=max(FiscalYear))} >}Revenue);

LET vRevenue = replace('$(vRevenue)','@','$');