If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Apply filter to data item with interval data type

Started by andysin, 22 Feb 2013 03:12:29 AM

Previous topic - Next topic

andysin

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..

andysin

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)