1 Reply Latest reply: Jun 3, 2013 2:30 PM by Curt Daughtry RSS

    sum of last 3 years avg, deliveries syntax

    Bradley Coyne

      Hi!

       

      i would like to find the avg amount from the last three years based on the key figure Delivrery total.

      my mission is to find out the average consumption per week of articles.

       

      Pseudo Code: avg(year = 2011, 2012,2013)), TotalDelivery) / 53 ( amt of weeks in a year)

       

      I was considering using set analysis , however once again my syntax fails me;

       

      any help would be greatly appreciated;

       

      Brad