Sum of calculated values in a group
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14264
Printed Date: 27 Apr 2024 at 10:00pm
Topic: Sum of calculated values in a group
Posted By: srij
Subject: Sum of calculated values in a group
Date Posted: 02 Sep 2011 at 9:06am
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 |
|
|