1 Reply Latest reply on Nov 6, 2018 7:47 PM by swaroop.gantela

    Averages

    Sean Bain

      Hi All,

       

      I am having a problem where in a sales environment when there are weeks with no sales the averages are only worked out across the weeks where sales occurred. Is there a fix for this? Many thanks in advance. Sean

        • 1. Re: Averages
          swaroop.gantela

          Sean,

           

          Apologies if you've already tried an discounted the below method.

           

          I'm not sure if this will work for your true setup, but I think you could try

          manually dividing the sum of sales by the number of weeks, something along the lines of:

          SUM([Sales]) /

          ( DATEDIFF('week',WINDOW_MIN(MIN([Datefield)),WINDOW_MAX(MAX([Datefield])) )

           

          could also be done with level of detail equations.