Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sunny,
It's VCurrentYear
=Num(Sum({<[Payroll year]={"=$(vCurrentYear)-8"}>}RESULT_VALUE),'#,###.00')
If this worked for you in a text box object -> $(VCurrentYear) - 8 (Gave you 2007), then this should work:
Sum({<[Payroll year]={"$(=$(VCurrentYear)-8)"}>}RESULT_VALUE)
It's Perfect Sunny !!!
Thank you sunny and Thank you all.