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

    Count if a condition is true?

    Hannah Keith

      Hi,

       

      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:

       

      SUM

      (

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

      THEN 1

      END

      )

       

      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?