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

How i filter the expression with min and max

luistarzia

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.

 

 

  • How i filter the expression with min and max
    Alexis Tan

    Hi,

     

    I don't know if I understood your question correctly, so tell me if im wrong okay?^^

     

    For example you have years 2010, 2011, and 2012

     

    do you want to sum the profit of all years (in this case 2010 AND 2011) that are < to your max year(which is 2012)?

     

    if so, can you try this?

     

    sum({<year = {"<$(=max(year))"}>}profit)

     

    or do you want to know only the profit of last year (2011) base on your max year (2012)?

     

    if this is the case then you can try this instead^^

     

    sum({<year = {$(=max(year)-1)}>}profit)

     

    Best Regards,

    Alex

  • Re: How i filter the expression with min and max
    Vincent Ardiet

    Hi,

     

    You can exclude the max year with a minus preceding the equal :

    =sum({<year -= {$(=max(year))} profit)

     

    Regards,

    Vincent