Running-Difference SQL

[testing123]

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

[Joker]

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