7 Replies Latest reply: Jan 17, 2017 8:07 AM by Magnus Buseth RSS

    Exclude null dimension from Aggr()

    Magnus Buseth

      Hi,

       

      I'm having some problems using Aggr() on data imported from Excel. Aggr() divides by 13 periods, instead of 12. I suspect the 13th period might be a blank row in my Excel file (period = NULL)?

       

      Please see the screenshot below for an example. I have included an Excel file with my data.

       

      How can I make Aggr() divide by 12 periods instead of 13 in this case?

       

      sum(Sales)/count(Period) = 136/12 = 11,33

      avg(aggr(sum(Sales),Period)) = 136/13 = 10,46

      aggr_example.JPG