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

    Sum if Sum - Condition Expression help

    Clint Siewert

      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 * 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