Aggregate & Upper Quartile Help

[#1]

Hi,

In the attached sample app I have the following straight table :

I 'think' I have calculated the 'AVG Calls per Unit' correctly by using an aggregate function. Is there any reason why it is only showing in one cell?

Also,  I need to create another expression where I need to calculate if each User carried out at least the average number of Calls for the unit - how many more calls could be made for this particular Unit.

Following on from this.  If each user carried out the total calls per session at least equal to the upper quartile (top 5) of users how many more calls could be made ?

Any help or advice on this is greatly appreciated.

Many thanks!

[sunny_talwar]

Sorry but I am lost on how this needs to be calculated? What are the numbers you expect to see?

[#3]

Hi Again,

In the attached example, where the user is above the Median Duration for the Unit I need to calculate how many more calls could be handled if they worked to the Unit Median Duration :

many thanks again for your help!

TJM