This content has been marked as final. Show 7 replies
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