AnsweredAssumed Answered

year-to-date for past years

Question asked by tma87 on Jan 15, 2019
Latest reply on Jan 15, 2019 by raym

I'm trying to formulate a report where it shows year-to-date actuals for the current year, and also where our actuals were on the exact same day for previous years. For example, today is January 15th, and I want the report to show:

 

Fiscal Year 2017: actuals from start of fiscal year to January 15th of fiscal year 2017

Fiscal Year 2018: actuals from start of fiscal year to January 15th of fiscal year 2018

Fiscal Year 2019: actuals from start of fiscal year to January 15th of this FY

 

I imagine this would include a time function in the layout such as "Yearly Cumulative Value" or something like this, but nothing I have tried has worked. Any ideas? Thanks!

Outcomes