Skip to main content
Planview Customer Success Center

Is it possible to calculate the percentage calculation using summed up values from grouping in Report Designer?

Question:
When creating a report that has grouping, so each row in the output contains summed data (for example total sales on projects associated with one project manager) then is it possible to have a calculated field on the report that uses the summed up (grouped) values? For example, to calculate a percentage?



Answer:
In a grouped table it is possible to calculate the percentage from the summed up values in columns, by using a custom field with the formula "Column1/Column2" and then using the “Apply formula-sum individual values” option in grouping options for this custom field.

In order to show the percentage of “Column1/ sum of all values in Column1” a pie chart needs to be used; it is not possible to show this value in the same grouped table.