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.
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.
Topics help categorize Community content and increase your ability to discover relevant content.
Ehm, "permission to stop banging your head" Kevin,
The "percent of budget used" is not possible with native reporting, but our Budget Vs Actual solution covers it perfectly, along with your custom quarter and multiple fiscal year requirements, too.
You're welcome to email me at firstname.lastname@example.org so we can chat further.
I do often feel like Workfront is trying to get me to beat my head into the shape of their lion favicon‚Ä¶
We actually do have "percent of budget used" for an entire project (works for us anyway), but breaking it down into fiscal years, quarters, or other smaller periods doesn't seem possible.
In that case, Kevin, if you flip the Lion upside down, it is turns into a Yoga Master: very Zen; very calming.
Back to Budget Vs Actuals...yes, I suspect we're describing different approaches: our solution handles % differences at the YYYYMM, YYYYQQ, and/or YYYY.