This is not quite what I had in mind. What I want to do is to use the max number of snaps for the period.
There will only be a daily snapshot for a material if there is an actual back order.
Material 123 was snapped 31 times in January and had a total backlog sum of $50,000. The Avg Daily should then be 50,000/31 = $1,613.
Material 456 was only snapped 10 times in January and had backlog sum of $75,000. The Avg Daily should still be 75,000/31 = $2,419.
In other words, I want the backlog sum to be divided by the total possible number of snaps for the period - not just the times that material was actually snapped.
What is happening in the workbook right now, is, that as soon as I filter on a specific material number, it will only show the number of snaps for that specific material, and daily avg then gets calculated based on that.