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.