4 Replies Latest reply on Feb 23, 2015 7:20 AM by Amber Smart

    Help with averaging variance calc

    Amber Smart

      Hey TUG!


      I am stuck and I am wondering if anyone out there has encountered this scenario and can walk me off the ledge


      I have attached a workbook that has over-simplified dummy data (but you get the idea) where I am looking at year over year variances by Region, but I am wanting to see what the average regional variance is by week (not the overall variance per week).


      Anyone in the group have any margin to take a looksie and see if you can shed some light on what I am missing? I will be forever grateful and those around me will be, too. Ha!



      Thank YOU!


      Message was edited by: Amber Smart