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