I have some expressions that give sales by year. i have some years that are zero and i am trying to ignore those zeros when using avg().
item 123 has sales in 2013, 2015, 2016 and 2017 but no sales in 2014 and 2018
i have a straight table that has the last 5 years sales (so i am not including 2013).
The AVG() is taking the full sales values (including 2013) and averaging it across all years, but what i actually want it to do is to only sum the years with values that i have in the chart (2015, 2016, 2017) and divide that total by 3 (as only 3 of the years have values)