Percent of Fiscal Year Budget | Community
Skip to main content
K
KevinQu1
Level 10
November 18, 2020
Question

Percent of Fiscal Year Budget

  • November 18, 2020
  • 2 replies
  • 704 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    November 18, 2020

    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 doug.denhoed@atppstore.com so we can chat further.

    Regards,

    Doug

    K
    KevinQu1Author
    Level 10
    November 18, 2020

    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.

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    November 18, 2020

    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.

    Regards,

    Doug

    Terms & ConditionsAccessibility statement

    Loading footer...