Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
perhaps the "AND" would be correct, as I am trying to limit the calculations between 0 and -20?
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])
to get values between 0 to -20 your comparison should be
<0 AND >=-20 (-10 is greater than -20, -30 is less than -20)