Sum If - If expression is true then 1 and sum those values not working

[Anonymous]

In my app I am capturing the Average QA scores for agents and identifying if they Exceed, Meet or Need Improvement.

The problem I am having is Totaling how many agents fall into each category. 

The expression to identify where they fall:

=if(avg(QAScore), < Only({<MetricID = {1} >} VariableValueBelow), 0,

if(avg(QAScore) >= Only({<MetricID = {1} >} VariableValueExceeds), 2,

if(isnull(avg(QAScore)), 0,

1)))

From the above I have broken out Below and Exceeds Figuring I could use the Count of Agents minus Below and Exceeds to find Meets:

Below:       if(avg(QAScore) < Only({<MetricID = {1} >} VariableValueBelow), 1)

Exceeds:   if(avg(QAScore) >= Only({<MetricID = {1} >} VariableValueExceeds), 1)

Name	Avg	Below	Meets	Exceeds	Agents
Dianna	97.53%	-	-	1	1
Gardner	93.57%	-	-	1	1
Michael	88.54%	-	-	-	1
Guadalupe	88.33%	-	-	-	1
Terry	88.22%	-	-	-	1
Sandra	85.40%	-	-	-	1
Kelley	82.73%	-	-	-	1
Reginald	81.16%	-	-	-	1
Pusey	79.47%	1	-	-	1

I am trying to get a final chart like this.  # of agents Below, Meets and Exceeds.

Below	Meets	Exceeds
1	6	2

Thank you for you help.

[#2 · Accepted solution]

try:

sum(aggr(

if(avg(QAScore), < Only({<MetricID = {1} >} VariableValueBelow), 0,

if(avg(QAScore) >= Only({<MetricID = {1} >} VariableValueExceeds), 2,

if(isnull(avg(QAScore)), 0,

1))), Name))

[Anonymous]

Alfredo thanks,

That didn't actually work for what I am trying to do but that put me on the correct path.  Breaking out each individually did resolve this.

sum(aggr(if(avg(QAScore), < Only({<MetricID = {1} >} VariableValueBelow), 1), Name))

sum(aggr(if(avg(QAScore), >= Only({<MetricID = {1} >} VariableValueExceeds), 1), Name))

Thank you.