Answered Calls >0 in the expression

[xarapre7]

Hi All!

The expression below includes CALLS_ANSWERED that are greater than 0.  How can I include in this expression to exclude the number of agents who have 0 CALLS_ANSWERED for a specific time frame?  I only want the count of agents with CALLS_ANSWERED >0 for its denominator.

=Num(Sum({1} Aggr((Sum( {$<TEAM = p(TEAM),EMPLOYEE_NAME=>}total<FULL_DATE>  CALLS_ANSWERED)/
Count({$<WM_TEAM = p(TEAM),EMPLOYEE_NAME=>} Total<FULL_DATE>EMPLOYEE_NAME)),FULL_DATE)),'#,##0')

Thank you in advance!

[xarapre7]

I don't have a whole number to divide the 6492 by.  What I'm trying to get actually is the sum of the Averages.  See below table to give you a clear picture of what I'm trying to do here.  Total calls = 6492 and the sum of the Avgs = 239.07

full_date	Yearmo	TotalCalls	TotalEmp	DailyTeamAvg
11/1/2016	201611	270	29	9.310344828
11/2/2016	201611	261	30	8.7
11/3/2016	201611	260	32	8.125
11/4/2016	201611	265	28	9.464285714
11/5/2016	201611	195	23	8.47826087
11/6/2016	201611	244	19	12.84210526
11/7/2016	201611	274	34	8.058823529
11/8/2016	201611	231	29	7.965517241
11/9/2016	201611	246	29	8.482758621
11/10/2016	201611	254	33	7.696969697
11/11/2016	201611	222	29	7.655172414
11/12/2016	201611	201	25	8.04
11/13/2016	201611	147	15	9.8
11/14/2016	201611	241	32	7.53125
11/15/2016	201611	267	31	8.612903226
11/16/2016	201611	243	26	9.346153846
11/17/2016	201611	213	27	7.888888889
11/18/2016	201611	230	28	8.214285714
11/19/2016	201611	162	26	6.230769231
11/20/2016	201611	174	19	9.157894737
11/21/2016	201611	256	31	8.258064516
11/22/2016	201611	216	29	7.448275862
11/23/2016	201611	196	30	6.533333333
11/24/2016	201611	96	27	3.555555556
11/25/2016	201611	154	28	5.5
11/26/2016	201611	126	22	5.727272727
11/27/2016	201611	139	19	7.315789474
11/28/2016	201611	229	31	7.387096774
11/29/2016	201611	236	31	7.612903226
11/30/2016	201611	244	30	8.133333333

[sunny_talwar]

Here you are:

Sum({1} Aggr(Sum({$<EMPLOYEE_NAME=,WM_TEAM=p(WM_TEAM)>}CALLS.CALLS_ANSWERED)/

Count({$<EMPLOYEE_NAME=,WM_TEAM=p(WM_TEAM)>} Aggr(If(Sum({$<EMPLOYEE_NAME=,WM_TEAM=p(WM_TEAM)>}CALLS.CALLS_ANSWERED) > 0, 1), DAY_MASTER.FULL_DATE, EMPLOYEE_NAME)), DAY_MASTER.FULL_DATE))

[xarapre7]

Sunny T!!!!  You're the best!!!

Thank youuuuuuu!!!

[sunny_talwar]

Hahahaha I took so long to come up with it, so I can't be the best . Anyways, I would request you to close this thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny