Set Analysis and Count if

[#1]

Dear Community

Please an i as advise on the following:

Below is my formula

=count(if(Aggr(SUM(Value),[Employee Name]) /10 > 0,{<Week={1}>},[Employee Name]))

I am not sure where to place the Set analysis because currently I have an error in the expression

Please advise

Many Thanks

[Anil_Babu_Samineni]

May be this?

count(if(Aggr(Sum({<Week={1}>}Value),[Employee Name]) /10) > 0,[Employee Name])

[#3]

Thanks for the quick response, however I still have an error in expresion

Regards

[Anil_Babu_Samineni]

Could be issue over 10. Would you able to share sample

[#5]

Hi

I cannot share, sensitive info contained. but I can see the expression editor is placing the red line behind the bracket of the 10. If this helps

=count(if(Aggr( Sum({<Week={1}>}Value),[Employee Name]) /10)> 0,[Employee Name])

[Anonymous]

try aggr(nodistinct ...

[avinashelite · Accepted solution]

try like this

=count(if(Aggr( Sum({<Week={1}>}Value),[Employee Name]) /10> 0,[Employee Name]))

[#8]

thank you

[avinashelite]

Glad to help you

[sunny_talwar]

Just for a try, this might work as well

=Count({<Week={1}, [Employee Name] = {"=Sum(Value) > 0"}>} [Employee Name])