Expand my Community achievements bar.

Sum numerical values in custom columns on parent tasks

Avatar

Level 1
We have added a few custom columns in our project task list that have numerical values. I know that you can create another column and add calculations, but we want it to work more like an Excel spreadsheet with sums on every parent task based on their child tasks (3 child tasks with 2 hours each = parent task sums to 6 hours). This works with the out-of-the-box data points (Planned Hours, Duration, etc) but I can't seem to figure out if we can get this same result with our custom data. Thanks! Erika Greene Project Manager Thomson Reuters Elite
1 Reply

Avatar

Level 10
Hi Erika, What you’re attempting should work as you expect, but since you're not seeing the summary amount, I'd suggest you: confirm that the underlying custom data parameter(s) are either Number or Currency ensure that in your report view, the column(s) of interest are also set to SUM Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads