Problem with Aggregation function

Wed, 04 Dec 2013 16:03:51 GMT

Hi Experts ,

I am trying to do this Aggr :

=Max(Aggr(Sum({$<Year ={">=$(=(max(Year ))-$(V_YearBack)) <=$(=(max(Year) ))"}>} Sales_EUR),Week_Extract))/1000

But this ... doesn't work !!

Any help is welcome

Thanks

Re: Problem with Aggregation function

MK_QSL — Wed, 04 Dec 2013 16:08:44 GMT

Try something like this

=Max(Aggr(Sum({$<Year ={">=$(=(max(Year ))-V_YearBack) <=$(=(max(Year) ))"}>} Sales_EUR),Week_Extract))/1000