title: Crystal reports formula for getting an average of group Minimum and Maximum running totals
body: <p>First question here.</p>
  
  <p>My question is how do I get an average of running total minimums and an average of running total maximums? I'm thinking I will need to use a formula rather than running totals but I don't know what that formula is.</p>
  
  <p>I'm writing a crystal report that gives occurrences of a thing over time. How  many times did a thing happen each month for a year grouped by month. Also, how long did it take to happen? Average time, Minimum Time, Maximum Time.</p>
  
  <pre><code>Year     | Month  | How Many | Average? (days) | Minimum Time | Maximum Time
  
  2017
  
  January  | 15      | 5       | 2           | 16          
  February | 7       | 4       | 1           | 10      
  March    | 20      | 6       | 4           | 12       
  Average  | 14      | 5       | 2.33        | 12.66 
  </code></pre>
  
  <p>I am using a running total in the month groups to get the average, min, and max for each month.</p>
  
  <p>But when I get to the average for all the groups, I want the average for all the minimums and the average for the maximums. I don't want the minimum for the year which would be 1. I could use a running total for that. I want 2.33.  Crystal doesn't let me to a running total average on running total minimums.</p>
  
  <p>I hope that makes sense. Thanks in advance for your help.</p>