7 Replies Latest reply on Jan 19, 2018 6:00 AM by Mark Bradbourne

    How to update KPI Calculated Field?

    Teresa Wright

      Recently the forum helped me with this KPI calculated field.  Now I need the KPI to display if the Status is "Approvals" or "Closeout".  How should I structure the statement?

       

      IF (SUM([Days Left])<30) and ATTR(Status) <> 'Approvals' THEN "•" ELSE " " END

       

      screen shot 1.jpg

       

      Thanks very much for your assistance!