Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
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))
.
Hi,
Can you share the mock data and expected output in excel format, tks
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))
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.