Expand my Community achievements bar.

The Community Advisors application is now OPEN for the second class of 2024. Apply to become a part of this exclusive program!

Report on Available Funds

Avatar

Level 2
Hello all! I have a user that manages requests for funds for various events. She has been managing these requests using Outlook (I know) and approached me about setting up a Request queue for her in Workfront. This is easy enough, but her reporting need has me scratching my head about how to do it. She wants to be able to report on funds remaining by basically saying (Territory Budget Amount)-(Sum of all completed requests for that territory). How would I do this? I'm familiar with calculated fields, but it seems like the Territory Budget Amount needs to exist at the Project level since it's a static number and not an aggregate. Any help is appreciated! David Ammons
1 Reply

Avatar

Level 10
It sounds like she'll have to enter that amount into a custom field that you create and attach to the request on a custom form.