5 Replies Latest reply: Jun 30, 2016 3:55 AM by Daniel Ansell RSS

    Help with a formula

    Claus Fuss

      I need, if it possible to write a formula, with this procedure,  I have a field called YEAR, so if this field is filtered (like I choose only data from 2015) then the formula must return year selected minus one (then 2014).   But if YEAR is not filtered then must return CURRENT year minus one. 

       

      Is this possible? can you help me

       

       

      Thanks in advanced