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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I sum a count?
- Thread starter sheely654
- Start date
IanWaterman
Programmer
YOu can use two additional running totals. In the evaulate part select formula and add condtions which meet the full time and part time criteria.
Ian
Ian
Or you could place a crosstab in the report footer that uses status as the row field, and count as the summary field.
Or, you could alternatively use conditional formulas:
if {table.status} = "Fulltime" then 1
Repeat for Parttime. Then place the formulas in the detail section and insert summaries (sums, NOT counts) on them at the grand total levels.
-LB
Or, you could alternatively use conditional formulas:
if {table.status} = "Fulltime" then 1
Repeat for Parttime. Then place the formulas in the detail section and insert summaries (sums, NOT counts) on them at the grand total levels.
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question