6 Replies Latest reply on Nov 27, 2018 5:39 AM by Kevin Warren

    LOD - Calculate Min Value That is Not 0 or Null

    Kevin Warren

      I am trying to arrive at the lowest non null or 0 value for my chart (see DOWN ARROW) , without excluding dates from my x axis.

       

      This is what I have so far:

       

      UTILIZATION (MIN) =

      IF(NOT ISNULL(WINDOW_MIN(AVG([Utilization Pct]),FIRST(),LAST()) )

      OR WINDOW_MIN(AVG([Utilization Pct]),FIRST(),LAST()) > 0 )

      THEN WINDOW_MIN(AVG([Utilization Pct]),FIRST(),LAST())

      END

       

      Utilization.PNG

       

      Please see attached workbook.