Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with Aggregation function

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

1 Reply
MK_QSL
MVP
MVP

Try something like this

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