?

[xyz1]

.

[Ralf_Heukäufer]

Hello Agrim,

a normal count around this does not work?

count(if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) ='2', Mission))

[xyz1]

.

[devarasu07]

Hi,

Can you share the mock data and expected output in excel format, tks

[pradosh_thakur]

where are you using the expression btw?

i would try this first

=sum(if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) ='2',1,0)

or

=sum(if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) =2,1,0)

try this too

count (if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) =2, Mission))

[Ralf_Heukäufer]

He can not count because you have a else clause:

I think

count(if(above(round(Avg(if(Not match([Action Plan], 'Totality of Action Plan'),[Rating #])))) ='2'))

for example should work.