2 Replies Latest reply: Jan 24, 2011 4:20 PM by Paulius Vebra RSS

    Sum if 2 conditions  with selections



      now i have such formula :

      sum({<Year={'$(=max(Year)-1)'}>} [liters purchased])


      so when i have selected Year 2011, this formula me returns previous year 2010, not looking that i have selected Y2011. - it's OK.

      now i want to add additional rule , also that should not look at selections. i have Local or Export sales, so i would like to add additional rule in this formula , is it possible ? so should be something like that : {<Year={'$(=max(Year)-1)'}>} { .... local...} [ liters purchased] .. ?