Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Look at aggr function.
Post sample of your data or your qvw file and expected result.
Do you want to do this in a text box or in a chart/table; and if chart/table, what are the dimensions?
Hi..
I want to display it in the Text Object
Hi Senthil,
Can you post some sample data and your expected ouput? So that it would be easier to give solution.
Regards,
Jagan.