COGNOiSe.com - The IBM Cognos Community

Hi folks,
I have a Data Item with the following way of calculating the count,
case
   when [Presentation View].[xxx].[TYPE] = 'A'
   then [Presentation View].[xxxx].[REC_ID]
   else null
end
And it is set to Count for the Aggregation.

Now I need to get this count for only for the last 30 days. I don't know
how to write the statement that would use a combination of above code
and the following to give me the last 30 day?

_add_days (_add_months (current_date,-1), -30)

Thx so much for your time.

Quote from: gosoccer on 02 Dec 2015 09:12:14 PM
Hi folks,
I have a Data Item with the following way of calculating the count,

Code Select Expand

case
   when [Presentation View].[xxx].[TYPE] = 'A'
   then [Presentation View].[xxxx].[REC_ID]
   else null
end
And it is set to Count for the Aggregation.

Now I need to get this count for only for the last 30 days. I don't know
how to write the statement that would use a combination of above code
and the following to give me the last 30 day?

Code Select Expand

_add_days (_add_months (current_date,-1), -30)

Thx so much for your time.

Hi,

Report Author is a role. Do you mean Report Studio?

If so, how about:

case
   when [Presentation View].[xxx].[TYPE] = 'A' and [Presentation View].[xxx].[YourDateItem] >= _add_days(current_date,-30)
   then [Presentation View].[xxxx].[REC_ID]
   else null
end

MF.

I meant Report Studio. Sorry, I do some security stuff in here too.

Yes, thank you so much. Thx should the trick.

I'll try it.
:) :)