Formula for Year to Date comparisons for this year and last year
Hello! I've been asked by my boss to create an Analyze report with year-over-year comparisons in it. I've had no issue getting indicators set up for weeks, months, and quarters.
What I am having issues with is setting up an indication that shows YTD information compared to the same time period last year.
I can do YTD this year compared to all of last year, but I can't seem to figure out a formula to get YTD last year. Maybe the YTDSUM formula can be used? or a combination of DAYDIFF, NOW, and something else?
Any help to figure this out would be much appreciated!
Hi Claire Findlay! I see that you have already reached out to our support team regarding this. I hope the solution provided was helpful. Please feel free to let us know if you need any additional assistance. Thank you! 😊
Basudha Sakshyarika Community Team at Wrike Wrike Product Manager Conviértete en un experto de Wrike con Wrike Discover
Basudha Sakshyarika Wrike Team member Conviértete en un experto de Wrike con Wrike Discover