2 Replies Latest reply on Jul 29, 2016 8:10 AM by Jacob Kreider

    Year Over Year Calculation Creating Null Values

    Jacob Kreider

      Hello,

       

      I have attached a workbook with data showing sales by day by location from April 2014 through June 2016.

       

      When I take average daily sales, by month over time, all values are present.

       

      When I do a quick tablecalc for year-over-year, or manually create it, I get null values for October-December 2015, even though the data exists for those months in both 2015 and 2014.

       

      Any help in understanding why this is happening would be greatly appreciated.