Rigsby Posted December 17, 2001 Posted December 17, 2001 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now