Calculating the X time as a proportion of total time

[megank]

Hi,

I am new to Crystal and am trying to do the following. I need to work out X time as a proportion of Time Worked for groups of people.

I have successfully worked out the X time as a proportion of time worked per person using the following:-

(({Time A}) - (sum({Time B},{person}))/({Time Worked})= Time C.

When I try and work out the total for each group using the formula below I get an incorrect answer:-

((sum({Time A}),{Group})))- (sum({Time B}),{Group})))/(sum(Total Worked},{Group})) * 100

When I just look at :-

(sum({Time A}),{Group})))- (sum({Time B}),{Group}))

I get the correct figure. When I divide it by the total time worked by the group it is incorrect.

I'd love some help??

 

[Madawc]

For Crystal 8.5, at least, Running Totals are handier than Sum values.

Madawc Williams
East Anglia, Great Britain