I have it working now by using IF statements so that if there are zero rooms sold, the values of the future months are listing zero rooms available and thereby not added into the YTD.

This doesn't work when all past months are not represented on the report. For instance,

MTD YTD LY MTD LY YTD