1 Reply Latest reply on Feb 23, 2016 6:45 PM by pooja.gandhi

    How to sum my IF formula

    Dominic Chindamo

      Hello everyone,

       

      I seem to have a problem trying to sum the total of '1's in my below formula. If you did this in excel you create an if statement and then do a pivot to sum all the 1 values. I was hoping to do the same with this but get no values.

      Any help would be great. Thanks.Dominic

       

      Capture.JPG

       

      Role:

      Discrete Measure

      Type:

      Calculated Field

      Default aggregation:

      Custom

      Status:

      Valid

      Formula

      IF ATTR([Priority])= "Medium" AND SUM(DATEDIFF('minute',[Submit Date],[Last Resolved Date])) >= 1440 THEN 0

      ELSE 1 END