Add Calculated columns to Group By Totals
Calculated columns are groovy but they are useless when used in combination of Group By Totals. The value in the row is not available to any of the Total calculations (Sum, Standard Deviation, etc.). The user is forced to calculate items in a workflow.
Ruben Ensalzado commented
Any update about this feature? I've seen it has been an ask since 2015.
If Microsoft is even promoting lists as a separate app, aggregation options for calculated columns are a must! There are currently two workarounds here: 1) power automate, 2) coding. In the first option, if one of the fields is another calculated column (typical when you have a column for a budget location and then select a labor rate based on that value) it does not appear on the Power Automate options; so you have to include the whole logic in the new field.
Natasha Penner commented
Yes please, I have a list for keeping track of test scores, and the score is calculated column (=[Earned]/[Possible]).
I would like to get an average of all scores as well as being able to group items by a category or person.
I can't use workflow to change this average based on different filtering or grouping, it all or nothing.