I have a resultset like this:
DATE NUMBER_OF_TASKS _CLOSED NUMBER_OF_TASKS _CREATED
PENDING_TASKS
----------
----------------------
----------------------- -------------
10/31/2007 1591
1723 132
11/01/2007 1821
4511 2690
11/02/2007 2465
5530 3065
11/03/2007 1028
1916 888
11/04/2007
1
1 0
PENDING_TASKS should be calculated as (NUMBER_OF_TASK S_CREATED -
NUMBER_OF_TASKS _CLOSED + PENDING_TASKS from Previous day).
While I can calculate NUMBER_OF_TASKS _CREATED -
NUMBER_OF_TASKS _CLOSED easily(which is shown in the resultset above),
I don't know how to add " PENDING_TASKS from Previous day". Pls help.
Thanks.
DATE NUMBER_OF_TASKS _CLOSED NUMBER_OF_TASKS _CREATED
PENDING_TASKS
----------
----------------------
----------------------- -------------
10/31/2007 1591
1723 132
11/01/2007 1821
4511 2690
11/02/2007 2465
5530 3065
11/03/2007 1028
1916 888
11/04/2007
1
1 0
PENDING_TASKS should be calculated as (NUMBER_OF_TASK S_CREATED -
NUMBER_OF_TASKS _CLOSED + PENDING_TASKS from Previous day).
While I can calculate NUMBER_OF_TASKS _CREATED -
NUMBER_OF_TASKS _CLOSED easily(which is shown in the resultset above),
I don't know how to add " PENDING_TASKS from Previous day". Pls help.
Thanks.
Comment