Average across groups in a table

JohnnyUtah — Thu, 29 Jun 2023 14:13:43 GMT

Hello,

I'm trying to calculate an average for a group and display it in a column in a straight table. Below is an example of what I'm trying to achieve.

For each Project I want a column to show the average COSTS for all projects with the same TYPE and Skill.

I've tried :

=avg(Aggr(Sum([Costs]),[Project], [Type],[Skill])) but that's not giving me the desired result.

Any suggestions would be much appreciated.

Thanks

Re: Average across groups in a table

Chirantha — Thu, 29 Jun 2023 14:40:42 GMT

Hey there,

Please try the following expression and see if it helps

=Avg({<[Project]>} Aggr(Sum([Costs]),[Type],[Skill]))

MarcoWedel — Thu, 29 Jun 2023 18:41:23 GMT

maybe this expression might work for you as well?

Avg(TOTAL<TYPE,SKILL> COSTS)

JohnnyUtah — Fri, 30 Jun 2023 12:46:14 GMT

Thanks Marco. That is the solution.