Hello,
I want to calculate the sum of the number of Days for a group. Values in # Days column are obtained by calculating the difference between the current performed date and previous performed date.
Currently, my total does not work. I do not see the # Days field to do a Running Total.
Please help me with this.
Below is my report:
|
Case # |
Comments |
Performed On |
# Days |
|
|
|
|
|
| Company Name 1 |
|
|
|
| Company
Division 1A |
|
|
|
1 |
test1 |
6/19/09 16:33 |
0 |
|
|
test12. |
7/8/09 16:59 |
13 |
|
|
test13 |
7/17/09 16:43 |
7 |
|
|
|
Total number
of days |
7 |
|
|
|
|
|
| Company Name 2 |
|
|
|
| Company
Division 2A |
|
|
|
26 |
test2. |
2/17/10 18:40 |
64 |
|
|
test22. |
3/17/11 19:04 |
281 |
|
|
test23 |
3/17/11 19:05 |
0 |
|
|
|
Total number
of days |
0 |
IP Logged