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


    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



          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.