Sum if Sum - Condition Expression help

[#1]

Hello,

Not sure if this is possible, but with the data I am working with I am stuck.

I have these fields:

Billable Hours

Network Days Flag

Employee

I am trying to perform a calculation if the...

(sum of billable hours) - (sum of Network Days Flag * 😎 >= 20, then sum the list of employees.

My current expression(that doesn't work):

Sum(if(Sum([Billable Hours])-Sum([Network Days Flag])*8>=20)[Employee])

Thanks in advance

[Anonymous]

Try this

if( Sum([Billable Hours]-(Sum([Network Days Flag])*8)>=20, count( distinct[Employee]))

[#3]

try this...i think do you need count Employee, no????

sum({<[Employee]={"$(=Sum([Billable Hours])-Sum([Network Days Flag])*8>=20)"}>} [Employee])

[vinieme12]

Assuming Employee is a numeric field!

Sum(

               if( Sum([Billable Hours]) - (Sum([Network Days Flag])*8)>=20,[Employee])

        )

[#5]

This has an expression error?

[#6]

Employee is not numeric, what could I do to solve this?  My issue is trying to chart (in some way) only a list of employees if they are 20 hours or more.  I have been trying to add filters, or an expression in several charts trying to accomplish this.  THANKS

[#7]

if( Sum([Billable Hours])-(Sum([Network Days Flag])*8)>=20, count( distinct [Employee]))

[#8]

I am only trying to show employees if they meet the condition of 20 hours or more.  Employee are names, not numeric.  Thanks

[#9]

count(distimc {<[Employee]={"$(=Sum([Billable Hours])-Sum([Network Days Flag])*8>=20)"}>} [Employee])

[vinieme12]

Rodrigo's Solution should work for you

or else try

Sum(

              if( Sum([Billable Hours]) - (Sum([Network Days Flag])*8)>=20,1)

        )

or

SUM(AGGR(Sum(

              if( Sum([Billable Hours]) - (Sum([Network Days Flag])*8)>=20,1)

        ),[Employee]))