10 Replies Latest reply on Jun 27, 2014 9:39 AM by Matt Lutton

    Variance Percent Calculations in crosstab

    Julia Hennelly

      I finally have a worksheet that is showing Actual Budget and Variance as I need it to.  Now I need to add a variance percentage which is the variance as a percent of the budget - tried various ways with no luck.  I also have Last Year Variance as a (ACtual - LY_Actual) and now I need to show last year % change.  For some reason I can not get these calculations to work.

       

      I then need to color code if variance % is less than last year % change.

       

      Workbook attached.

       

      JUlia