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

[#2]

perhaps the "AND" would be correct, as I am trying to limit the calculations between 0 and -20?

[#3]

Perhaps something like this?

AGGR(if(sum([Billable Hours]) - (Sum([Network Days Flag])*8) < 0 AND AGGR(if(sum([Billable Hours]) - (sum([Network Days Flag]) * 😎 <= -20)),[Employee]),[Employee])

[vinieme12]

to get values between 0 to -20 your comparison should be

<0  AND >=-20  (-10 is greater than -20, -30 is less than -20)