This content has been marked as final. Show 2 replies
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.