3 Replies Latest reply: Jul 6, 2011 11:39 AM by Tim Benoit RSS

    How to make Avg ignore null values

    Tim Benoit

      Does anyone know how to make the AVG calculation in a chart expression ignore null values?     For example, if I have three values:  3, 5, and null; then I would want the average to be 4, not 2.67.