1 Reply Latest reply on Jul 27, 2015 3:55 PM by hannah.johnson

    Average and Difference of Average calculation

    rahul.mamtora

      Hi,

       

      I have attached an excel file, request to refer this. I have Census data for Jun Actuals that i am comparing against the AOP and Prior Year. For this I am calculating the average as of June that shows at the bottom.

       

      So I want to achieve average of AOP vs Actuals and average of PY vs Actuals.

       

      Request all to help me solve this.

       

      Thanks