Post

2 followers Follow
0
Avatar

Get the sum of selected cells?

Hello,

Could you please tell me if there is a way to display the sum of values (duration for example) from selected cells in Clarizen.

As a Use case example, is there a way to get the sum of selected values in Resource Load View, to easily get the sum on the year for a set of tasks for example.

The current workaround is to export the resource Load to Excel, and then use Excel for the maths. Is there a more integrated solution in Clarizen?

Thank you in advance.

Best Regards,

Armand

Armand BOLMONT Answered

Please sign in to leave a comment.

1 comment

0
Avatar

Yes, but it depends on which grid you are referring to. You can create a roll-up summary field in work items, but cannot create a similar field for the Resource Load View. I would recommend working with Professional Services for a use-case-specific solution. One other option could be an Excel Add-in Report that is fully automated--you open the report and it refreshes with the latest data.

Josh Santos 0 votes
Comment actions Permalink