Create YTD for Current and Prior Year

[britknip]

I need to create a YTD (Jan-Apr) column for current year and prior year. I have multiple rows that need calculated. See attached.

Need:

Current Year YTD Actual

Current Year YTD Budget

Last Year YTD Actual

Thanks!

[LordNeilLord]

Hey @britknip

Something like this?

[britknip]

Thanks @LordNeilLord However, I have to have new, separate columns next to my existing data. If I do this, I believe it will override my current month to date data. I need my output to look similar to this

Date     FSParent     Actual     Budget     Last Year     V_Budget     V_Last Year     YTD Actual     YTD Budget     YTD LY

[LordNeilLord · Accepted solution]

So more like this?

[britknip]

Yes, exactly what I needed. Thank you!