Aggregate scoped hours by resource and project

[NickVa1]

Hi Community,

I have an Assignment report that breaks down the planned hours and planned revenue by project and assignee (we sometimes have many assignees on one task).

For the planned revenue value, I want to roll it up to the resource and project groupings, but I'm having trouble doing so.  I feel like I've read in the past that you can't aggregate a custom column that has a valueexpression calculation in it.  My planned revenue field is a custom calculated column, taking the planned hours for a resource * their job role bill rate.  I had to do this because this is an assignment report, not a task report where planned revenue is a standard field.

Here's what I have:

Can't do a custom field on the assignment object.

Thanks,
Nick

[Sven-atClient]

Hey @NickVa1   
How goes! 

According to this you now CAN associate custom forms with assignments

https://experienceleague.adobe.com/en/docs/workfront/using/adobe-workfront-api/api-notes/new-api-ver...

[Doug_Den_Hoed__AtAppStore]

Hi @NickVa1,

That's a complex course you're charting (even with the new Custom Forms on Assignments; nice pull, @Sven-atClient), so I invite you to consider our AFA Burn Report solution, including this video to see how it rolls up hours and dollars by user > role > department > project.

Regards,

Doug