Count If

[odo_nogk]

Hello Experts!

I am looking to count the instances of an if condition.

My calculation is;

if(sum([Output])>= (sum(Plan)*.90) and sum([Output]) <= (sum(Plan)*1.10) ,1,0)

I want to count how many times the true value 1 occurs.

Not sure if set analysis will make this easier?

Thanks!

[sunny_talwar · Accepted solution]

What dimension or dimensions are you checking these condition against? May be try this

Sum(Aggr(
  If(Sum([Output]) >= (Sum(Plan)*.90) and
     Sum([Output]) <= (Sum(Plan)*1.10), 1, 0)
, Dim1, Dim2, Dim3))