Mtd / ytd baq

I need a few BAQ’s that all have the same format, which I’m not sure about. I already have the GL Account, MTD Actual, MTD Budget and Variance, but I’m not sure how to get the YTD Actual and YTD Budget.

GL Account - MTD Actual - MTD Budget - Variance - YTD Actual - YTD Budget - Variance

Thanks, Tim

Why can’t use just use the year instead of the month? I’m not understanding why you can’t get month to date, but not year to date.

You will likely need a sub-query to sum some fields. However, how are you getting the MTD values?

Right now I selected the Fiscal Year and Fiscal Period. Eventually, I’d like it to be the Fiscal Year and Fiscal Period of today’s date.