Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Aggregate scoped hours by resource and project

Avatar

Level 10

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:

NickVa1_0-1728422929923.png

 

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

Thanks,
Nick

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Community Advisor

 

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