2 Replies Latest reply: Dec 5, 2016 2:14 AM by Lakshmikandh Karthikeyan RSS

    Sales for current and previous year with if statement

    Mike Smith

      Hi Everyone,


      I am looking to create an if statement calculation that says: if it is the current year then return sales.


      If possible, I want to accomplish this without a set analysis and without having to create a master calendar as these are just quick calculations that need to be made.


      I have something like: sum(if(year(Booked_Date)= Max(year(Booked_Date))), Booked Amount))


      Can't get this to work for some reason.


      I am also trying to do the same for the previous years' sales.


      Please let me know if I'm missing something.