COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 24 Nov 2008 12:08:14 PM

Title: How can I get last week counts
Post by: jd on 24 Nov 2008 12:08:14 PM
Any Idea How can I get last week counts in my report.
Title: Re: How can I get last week counts
Post by: Suraj on 24 Nov 2008 12:36:41 PM

case

when ([Date Column] >= adddays(current_date,-7) and [Date Column] < current_date) then (count ([Apps])

else null

end