Hello,
I need to create a data item for a running difference between rows that contain date/time data items. I'd like to cast it as a date, then do the running difference. The data item name (column) is [Status Date/Time]. Running Cognos 10.1.1.
Thanks!
-J
Quote from: testing123 on 22 Dec 2014 11:46:58 AM
Hello,
I need to create a data item for a running difference between rows that contain date/time data items. I'd like to cast it as a date, then do the running difference. The data item name (column) is [Status Date/Time]. Running Cognos 10.1.1.
Thanks!
-J
Hi,
I believe running Difference can't be used with dates.What you can do is-
1. Create a data item(say rownum) in the present query that will show the row numbers.
2. Create a new query with same data items as in previous query and create another data item whiich is like query1.[rownum]+1.
3. join these queries based these data items and then calculate the difference of two fields.
Regards,
Joker