title: Crystal Reports 2013 How do I exclude Null Values in a Crosstab average?
body: <p>How do I get a crosstab in Crystal Reports 2013 to exclude null values from a crosstab average? </p>
  
  <p>For example
  <br>
  Procedure Name : OCT RETINA
  <br>
  Procedure Count : 8
  <br>
  Procedures with Completion Times Populated : 6
  <br>
  Summary of all 6 Completion Times : 101
  <br>
  I was expecting the average of the Completion Times to be calculated as 101/6. Instead, Crystal Reports is calculating the average as 101/8. It needs to be calculated as 101/6 (without counting null values in the denominator).</p>
  
  <p>Adding another group is not an option because of the very specific way the values are sorted in the detail (hence a crosstab in a footer). The names of the procedures are dynamic so keeping a running total of each procedure's average completion time is not an option either. </p>
  
  <p>Thanks in advance!!!!</p>