Avg of Calls and Print text objects

[xarapre7]

I would like to do an average of the below but, I'm not getting the correct result. 

=Num(Avg({$<EMPLOYEE=,TEAM=p()>} CALLS_ANSWERED),'#,##0')

Description	Individual	Team
Calls Answered	2,000	Avg of the Team
Average Handle Time	22:37	25:11

Also, i have a couple of text objects to get different call metrics.  I would like the capability to have these

text objects printed altogether in a sheet (as seen in the above table).  How should i do this?  Can you please help?  Thank you in advance for your assistance.

[sunny_talwar]

What is the exact expression you tried?

[xarapre7]

=Sum(Aggr(Num(Aggr(Sum({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME>} CALLS.CALLS_ANSWERED),EMPLOYEE_NAME),'#,##0')/ (Avg(Aggr(Sum({<DAY_MASTER.FULL_DATE, EMPLOYEE_NAME >} CALLS.CALLS_ANSWERED),EMPLOYEE_NAME))), EMPLOYEE_NAME))

[sunny_talwar]

Full_date is a dimension also, right?

=Sum(Aggr(Num(Aggr(Sum({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME>}CALLS.CALLS_ANSWERED),EMPLOYEE_NAME),'#,##0')/ (Avg(Aggr(Sum({<DAY_MASTER.FULL_DATE, EMPLOYEE_NAME >}CALLS.CALLS_ANSWERED),EMPLOYEE_NAME))), EMPLOYEE_NAME, full_date))

[xarapre7]

yes, that is correct.  full date is also a dimension

[xarapre7]

I tried the latest expression and it's still gives a result of just 1.

=Sum(Aggr(Num(Aggr(Sum({$<WM_TEAM = p(WM_TEAM), EMPLOYEE_NAME>}CALLS.CALLS_ANSWERED),EMPLOYEE_NAME),'#,##0')/ (Avg(Aggr(Sum({<DAY_MASTER.FULL_DATE, EMPLOYEE_NAME >}CALLS.CALLS_ANSWERED),EMPLOYEE_NAME))), DAY_MASTER.FULL_DATE))

[sunny_talwar]

Did you remove EMPLOYEE_NAME dimension? May be add it back? If it still doesn't work, I guess it would be nice to see a sample?

[xarapre7]

How can I attach a file in here?

[xarapre7]

Please see attached sample in excel of the raw data.

[sunny_talwar]

This doesn't look like raw data This seems to be pre-aggregated data from your chart in QlikView. Can you share your qvw?

[xarapre7]

it's a large file.  I'll try to take out the other tabs.