1 Reply Latest reply on Oct 13, 2018 5:42 AM by Akram Ebrahim

    How to ignore 0 months in yearly average

    Alex Martino

      Hello. I'm trying to create a yearly daily average by product BUT I don't want to include months where the average was 0 (that is there were no sales)

       

      This is the formula I'm currently using. The problem is that for products that get released later in the year, it is dividing the daily average by 365 days, and I don't want it to included months with an average of 0.

       

      AVG({ FIXED [Category], [Date]: SUM([Sales Volume])})