Sum FTE Totals for all assigned projects
Hello,
I am looking for some assistance with summing the total FTE hours per person assigned to a project. We use increments of .05 which is always rounded to 0 in the pivot app. I can't achieve this sum in reports, for some weird reason it won't allow me to group or summarize the Assigned Resource column. Is there a formula that I could use instead?
Thanks so much!
Answers
-
Hi @Katye Reed
Have you tried increasing the decimal on the Pivot output sheet columns? This should show you 0.5 instead of 0, like so:
For your Report, is the Assigned Resource column a multi-select column? Currently it's not possible to use Grouping and Summary on multi-select columns, but if you only have one selection in the column anyway, turning off the ability to add multiple contacts will allow you to use this column.
If neither of this has helped, it would be useful to see a screen capture of your source project sheet (but please block out sensitive data).
Thanks!
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!