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.

[xarapre7]

Like the one I've shown above.

What this is going to do is, the user needs to select an employee first from the Filter Selection.  And based on that employee that's been selected from the list, the above metrics should be displayed.  So the employee's number of calls answered and the employee's team's AVG # of calls answered.

[sunny_talwar]

How about this?

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

[vishsaggi]

Is the expression not working it is not giving you the avg of 5?

In the above output you need the Sum and avg on two different tables or one below the other ?

I used your expression in the team average like

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

[xarapre7]

Hi Sunny T!

Thanks for the input.  I've already tried doing that and it didn't work.  It just gave an output of dash (' - ').

[vishsaggi]

Can you share your sample app you were working on which you are not getting the desired results?

[xarapre7]

did you see the file?

[vishsaggi]

Nope, dont see any attachment!

[xarapre7]

Here you go. 

[sunny_talwar]

Are we looking to get this right?

0:12:20 is not right for Abas, Lendion Zachary?

[xarapre7]

That one and the one above that.  The Calls Answered for the Team.  We want the Avg per Team.