13 Replies Latest reply: Sep 14, 2015 6:38 AM by KALYAN KRISHNA RSS

    Set Analysis

    KALYAN KRISHNA

      Hi,

      I'm having data from 1995 to 2007 only. I need to show the 2007 data as current year and Previous Year as 2006.

      I created a variable in Load Script as

      SET VCurrentYear=Year(Today());

      I used this variable in set analysis.I'm not getting the data .I don't know where i went wrong.

       

       

      Num(Sum({<[Payroll year]={$(=vCurrentYear)-8}>}RESULT_VALUE),'#,###.00')

       

      I checked $(VCurrentYear)-8 in the Text Object it's showing the year as 2007. But in set analysis its not working.

       

      Can anyone please suggest me.

       

      Regards

       

      krishna