2 Replies Latest reply on Jun 26, 2018 11:34 AM by Hannah Keith

    Count if a condition is true?

    Hannah Keith



      I'm trying to get a count of days when planned production (FPS Plan - Stat CPD) is greater than 0 for the filtered date range.


      My current formula "Days of Planned Production" is:




      IF { FIXED [Day Math Date] : SUM([FPS Plan-Stat]) } > 0

      THEN 1




      Now days with no data are no longer counted, but days with a 0 in the FPS Plan - Stat CPD field are being counted when I don't want them to. Any ideas on how to change by formula?