2 Replies Latest reply: Jul 20, 2013 2:28 AM by Gysbert Wassenaar RSS

    Set Analysis Expression not Working

      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.