Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

?

.

5 Replies
Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

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
Creator III
Creator III
Author

.

devarasu07
Master II
Master II

Hi,

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

pradosh_thakur
Master II
Master II

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))



Learning never stops.
Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

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.