Ratio drawn from two subtotals

[kieso]

I’m new to the Group, and somewhat new to Crystal. I hope the question isn’t too stupid, but for the life of me I can’t figure out how to do it.

I’m tracking on-time dispatch. I look up dispatch time, and compare it to another field showing actual depart time. By comparing the two, and allowing for a 10 minute grace period, I determine if the driver left “on-time” or not.

The simple version of my existing report is shown below.

pete ontime hidden formula result 1
steve ontime hidden formula result 1
albert ontime hidden formula result 1

albert late hidden formula result 0
melissa late hidden formula result 0
tammy late hidden formula result 0
George late hidden formula result 0

total dispatches (subtotal count of all runs) 7
total ontime (subtotal – sum of the hidden formula result) 3

------------------------------------------------------

Now the report needs to include a departmental percentage (only one department so final totals can be used). How do I apply a formula to the two subtotals (3/7=42%) in Crystal reports? If you can't, do you have to create a new table? Maybe a summary report is the right approach. Any ideas?

Ultimately I’m going to also want to create another report that shows this “Departmental on-time dispatch percentage” as a line graph or a table for showing the value each day for a whole month, or the whole quarter. If a whole new table is needed for that report, then maybe I could build it and use the daily percentages it creates in the daily detail I’m building now. Quite honestly, though, I'm not sure how to create that next report, yet either

Thanks in advance for any ideas

Rodger (the Crystal neophyte) )
MA, USA

 

[IdoMillet]

One approach is to simply create the following formula:

100*SUM({your_1_0_Formula})/Count({your_1_0_Formula})

The sum would return 3 in your case and the count would return 7.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com