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

    Last year Sales in Script

    Alexander Müller

      Hello,

       

      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