23 Replies Latest reply: Jul 29, 2016 3:46 AM by Vineeth Pujari RSS

    Sum if Sum - Condition Expression help


      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



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

      (sum of billable hours) - (sum of Network Days Flag * 8) >= 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