6 Replies Latest reply on May 26, 2017 1:20 PM by Shinichiro Murakami

    How to make a blank = 100%

    Chrissy Scott

      Hi All,

       

      Need some help with an availability calculation. I'm trying to create a trend (by quarter) for service availability. When there was some service down time, the calculation works fine. What I can't sort out is how to get a blank to show as 100%. In other words, if a service did not have any outages (0 hours of down time) for the entire quarter, my chart is showing a blank column. Like this:

      What I want is for that FY17 Q1 column to show at 100%.

       

      Workbook attached. Any ideas?

       

      Thanks,

      Chrissy