Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Count of a Summary

May 14, 200322 yr

(edited to add some more info...trying to clarify my problem)

I have a report that has no body - just multiple subsummaries, in a large line item file. Every record in this file is an line item from a timesheet - related to both a staff member (who exists within a department and within a company) and a project.

The Subsummaries are:

Company

Department

Staff Member

Project Name

All of which have an hour total and a cost total, using summary fields.

I want to also include a summary of the count of projects. So a staff person clocks 36 hours, costing $720, and worked on 7 projects total (each project also has a break-down of hours and cost).

But if I create a summary field that is the count of Project Name, I get the number of records (which might be 79) - not the number of Projects.

Can I get a count on a summary?

Many thanks.