Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this....
avg({<Year={2011,2012,2013}>} TotalDelivery) / 53