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))
