5 Replies Latest reply: Jan 23, 2018 7:27 AM by Ralf Heukäufer

# how to count?

Hi,

i want to count this -

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

Regards

• ###### Re: how to count?

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

• ###### Re: how to count?

obviously not my friend, i tried a lot

• ###### Re: how to count?

Hi,

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

• ###### Re: how to count?

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

• ###### Re: how to count?

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.