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