Print Page - Apply filter to data item with interval data type

Title: Apply filter to data item with interval data type
Post by: andysin on 22 Feb 2013 03:12:29 AM

I subtract date1 and date2 to get the difference in minutes.

However, when I put a filter if (difference > 15) then (1) else (0)... it does not allow me to do it.

Seeking if there is another or better to do this..

Title: Re: Apply filter to data item with interval data type
Post by: andysin on 22 Feb 2013 03:21:55 AM

I managed to do it but if there is any better way then it will be good to know.

minutes(date1) - minutes(date2) = difference

if (difference > 15) then (1) else (0)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: andysin on 22 Feb 2013 03:12:29 AM