Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Showing percentages in a Subsummary


This topic is 8376 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I need to show percentages in a subsummary part

The example is as follows:

I have an appointments database that uses the following fields

Appointment_Date

(Appointment_Year)

Appointment_by

Appointment_Result1, 2 & 3 (Success, Fail, & Open)

So, I use the sort: (Appointment_Year) and Appointment_by

And thus display, e.g.

________________

Subsummary1:

Year: 1999 /Appointments 75 / Success 49 / Fails: 20 / Open: 6

________

Subsummary2:

Mike: Appointments 20 / Success 15 / Fails: 5 /Open 0

Dave: Appointments 25 / Success 10 / Fails: 10 / Open 5

Mike: Appointments 30 / Success 24 / Fails: 5 / Open 1

Etc.

What I need, however, is to also show the percentages for each employee: i.e.???

Robert: Appointments 100 / Success 50 (50%) / Fails: 25 (=25%) / open 25 (=25%)

Please note, that after the whole statistic has displayed, the next year comes, s in the case above for the year 2000, then 2001 etc.

This topic is 8376 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.