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

    Help with a formula

      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