Calculating on an If Statement

[#1]

Is it possible to sum one of the values in a calculated if statement. For example, I want to sum the # of 1s in the field "If(Sum([Met Target (Value)]/Sum([Count Quarter]0>.5,1,0)

[sunny_talwar]

Try this:

Sum(Aggr(If(Sum([Met Target (Value)]/Sum([Count Quarter]0>.5,1,0), YourChartDimensionsHere))

[#3]

what do you mean y yourchartdimensionhere

[sunny_talwar]

What all dimensions are you using in your chart above? Add all of them in place for the place holder -> YourChartDimensionsHere separated by comma