Is this example I using the above function to create a rolling average of sales over a 3 week period. If I get a report of sales each week then everything works fine (That would be product A in the example). My problem is for some inputs of if they don't have any sales for a product during a week they don't report a value at all (products B,C) in the example
Is there a different function to use or what have other folks used to handle this situation.