I have a calculation I can't wrap my head around, and I am kinda thinking can't be done as a field calculation (would normally be done via a dedicated report).
We track budgets on a project by fiscal year (separate custom field for each fiscal year). Projects often span multiple fiscal years, thus multiple budget "buckets." We use custom fiscal quarters/years (July 1 - June 30).
Getting the burn against the entire project is easy, and we display that as a "percent of budget used" custom field.
REQUEST:
There is need to show the percent of budget used specific to each fiscal year of the project and display as a project-level field.
Any ideas?