Count if

[#1]

Dear Community

I am having a difficulty with the following formula:

=Count(if(SUM(Value)/10 > 0.8,[Employee Name])

I am not getting a result.

Please advise

Regards

[Anonymous]

Don't know what your data looks like but you can try this.

=if(aggr(sum(Value)/10,[Employee Name])>0.8,count(distinct [Employee Name]),)

[ziadm]

missing closing bracket ...

=Count(if(SUM(Value)/10 > 0.8,[Employee Name]))

also you are missing aggr function

Try

=Count(if(Aggr(SUM(Sales),Customer) /10 > 0.8,Customer))

[#4]

Thanks , I am still trying but not getting result

[#5]

Thanks, Still no result , I will follow the formula, probably missing a bracket somewhere on my side

[ziadm]

=Count(if(Aggr(SUM(Sales),[Employee Name]) /10 > 0.8,[Employee Name]))

[#7]

Great , thanks a million - works

[ziadm]

Please mark correct and close the thread .. Thanks