Create column filters for "budget" being most recent updated budget (with adjustments) relating to filters like "actual"

Currently, when you have a budget column in a Income Statement report, it needs to be one of the two variables: Original budget, or Adjusted budget. I propose to create a variable that pulls the "most recent" budget and responds to filters. e.g. if the filters is set to this fiscal year, it will automatically pull this fiscal year's last budget. Otherwise, you have to update all reports every year to correspond with the correct budget. 

  • Friso Kuiper
  • Nov 13 2019
  • Needs review
  • Attach files