Report Studio - How to calculate [Year To Date Last Year]

Cognos 10 Business Intelligence Report Studio
1

Hi,

I can’t seem to find the correct way of calculating (YEAR TO DATE of last year).

Anyone can suggest something ?

Thanks !

2

Are you looking to make a filter or a calculation?

If you’re looking for a calculation, what are you trying to calculate? how many days since 1/1/13 to current date?

3

Hi Roger,

Sorry for my reply’s delay as for i have and still am pretty busy here …

We finally managed to create the following Data item calculation and it works so thank you anyhow for your post:

Total ( if ( [Num Year] =
if ( _day_of_year ( current_date ) = 1 )
then ( year ( current_date ) - 2 )
else ( year ( current_date ) - 1 )
and [Day In Year] < _day_of_year ( current_date ) )
then ( [Total Sales Amount] )
else (0) )