2 Replies Latest reply: May 8, 2012 1:52 AM by Vincent Ardiet RSS

How i filter the expression with min and max


Hello everybody.

I have an expresion similar that  =sum({<year = {2011,2010}>} profit)


I need sum the profit only a years different from the max of year in this case 2012

If i write =sum({<year={$(=max(year))} profit) run and sum the [profit for the max of year but shows error if i replace the = for the << for given the sum of years that are minor of 2012.

How i write the expresion ?

=sum({<year << $(=max(year))>} profit) shows error.

Thanks in advance.