Average for a Team

[#1]

Hi Friends ,

I have a requirement , where i have to find the average for a Team  and Individual.

i was able to find the average for individual. The expression used is

=((Sum({$<Type = {'Break Time'}>} Duration)/60)/ (Count( DISTINCT{$<Type = {'Break Time'}>} Date)))

Now i have to find the average for the team. How do i acheive it.

The Team header is StaffUnit.

Regards,

Senthil

[robert_mika]

Look at aggr function.

Post sample of your data or your qvw file and expected result.

[jonathandienst]

Do you want to do this in a text box or in a chart/table; and if chart/table, what are the dimensions?

[#4]

Hi..

I want to display it in the Text Object

[jagan]

Hi Senthil,

Can you post some sample data and your expected ouput?  So that it would be easier to give solution.

Regards,

Jagan.