Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Group Level Formula's & Grouping
( select max(A.`field`) from Table A where A.`groupfield` = Table.`groupfield` ) Could you define A, field, and groupfield for me. The table that contains the rate is called 'eePayCodes', the table that contains the Employee # is called 'eeKeys' So would it look like the following? ( select...- 6453kelly
- Post #7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Group Level Formula's & Grouping
OK so #1 worked swimmingly. Thanks. For #2 I'm a little confused, so I'm going to give you a more detailed description. Sample Raw Data Emp # > Rate > Amount 001 > 0.35 > 10 001 > 1.70 > 20 001 > 0.00 > 10 002 > 0.35 > 20 002 > 0.35 > 10 003 > 0.35 > 20 004 > 1.70 > 10 I grouped the data by...- 6453kelly
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Group Level Formula's & Grouping
a sum of the group level formula results. crystal 8.5- 6453kelly
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Group Level Formula's & Grouping
I have the following questions regarding a report I'm trying to develop in Crystal. 1. I have a formula that is calculated at the group level. It is the sum (field A) divided by the distinct count of (field B). The formula works fine, but I now want to have a grand total for the formula, and...- 6453kelly
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 1 Formulas
