Average of the excluded values

Mauritz_SA — Tue, 28 May 2019 11:03:49 GMT

Hi everyone

This might be a simple question, but I can't seem to wrap my head around it. I have a table which can be simplified to the one below:

Class	Group	Score
A	1	10
A	2	20
A	3	50
B	4	80
B	5	85
B	6	40

I want the average score for my selections which I can get by using a simple Avg(Score). When I select Class = A and Group = 2 then my Avg(Score) will give me 20. How can I get the average for the scores in my selected Class (A), but for the Groups which are not in my Group selection (1 and 3). In other words, when I select the class and group in green in the table below, I want to get the average of the blue values (=(10+50)/2=30).

Class	Group	Score
A	1	10
A	2	20
A	3	50
B	4	80
B	5	85
B	6	40

Please let me know if anything is unclear.

Regards,

Mauritz

Re: Average of the excluded values

lironbaram — Tue, 28 May 2019 11:22:30 GMT

this expressions will do the trick

Avg({<Group=e(Group)>}Score)

what it does , it disregards the selection in the group field and instead use the excluded values from the field

Re: Average of the excluded values

Mauritz_SA — Tue, 28 May 2019 11:33:53 GMT

Hi @lironbaram

Thanks, works like a charm.

Regards,

Mauritz

topic Re: Average of the excluded values in App Development

Average of the excluded values

Re: Average of the excluded values

Re: Average of the excluded values