0 Replies Latest reply: Mar 19, 2010 11:05 AM by Norma parker RSS

    How to create a rolling 3 month avg. while skipping null/zero values

       

      I need to create a rolling 3 month average that skips over a null value.

      For example:

      Company 1 has data for Jan, March, and April but a zero value for Feb. I need the rolling avg. for April to include April,March, and Jan skipping over Feb.

      The chart expression I am using now includes the zero Feb. value.

      =rangeavg(before(SUM(Ext Rebate)/SUM(Ext Unit Price),0,3))

      Thanks !