2 Replies Latest reply: Mar 20, 2017 5:28 AM by Sunny Talwar RSS

    Last year Sales in Script

    Alexander Müller



      i want something like this:


      if(Year = '2017',Price*Percent,Price) as New_Price


      If the Year is '2017' it should take the Price from Year = '2016' and so on...

      Always the last year Price.


      Thank you