Calculating %

[Vo0do0uk]

struggling with this one.

I have a DB for a restaurant, and a report i have shows all the labour %'s for each day.

i want the form to total all these labour% up and give an average labour % for the week.

but it aint happening!! keeps coming up with stuff like 2123.00%!!

I have created a text box, and inputed the code as =Avg([Labour %]) where Labour % is the name of my text box containing each %

i then set the running sum to all three options!! (no,over all, over group)

but didn't work for any! i also tried to use =Sum

I'm guessing i'm having troubles because %'s in general are a pig!!

any ideas guys??

 

[Rich]

I don't know how you're calculating the average per employee but you have to repeat the calculation i.e.

=Sum([HoursWorked])/400 where 400 represents a 40hr week for 10 employees, it's a bit more involved dynamically of course.