5 Replies Latest reply on Nov 21, 2013 5:14 PM by Michael Evans

    Counting nulls as 1 instead of a zero in table calculation

    Greg Cowart

      Hello,

       

      I'm trying to figure out how I can count nulls as 1 instead of a zero in the attached workbook.  As is, the null values do not count as a day meeting the requirement and are counting against the metric, I would like them to count as meeting the metric.

       

      Additionally if anyone knows how to hide of the dates and just keep the three summary fields Service Level Met, # of Days in Period, and % Service Level that would be great too.

       

      Any help would be greatly appreciated.