I have a report grouped by providerid. Within the group footer I sum the toal trip , aslo wrote formulas to sum trip between 0 and 5 minutes late, 5 to 10 minutes late etc for 5 sets. When I inset a sum and check show as a percentage of it gives for the whole report instead of the grouped total for the provider, is there any way I can get the percentage of the 0 to 5 to the total for the grouped trips.

Thanks I took your logic and applied it a little differently but it works.