Calculate difference to Total average expression

[#1]

Name	Skill	Avg Score	Difference against total average	Above/Below
		2.82	How do I make this column?
Name 1	1	2.50	=2.82-2.50 (Column should show 0.32)	Above
Name 2	2	3	=2.82-3 (Column should show -0.18)	Below
Name 3	1	3	=2.82-3 (Column should show -0.18)	Below
Name 4	2	2.80	=2.82-2.80 (Column should show 0.02)	Above

Im struggling on how to calculate the above.

I would also like to know that if I was to add conditions in set analysis i.e. Skill = 1 only if I would have to do it differently.

Best,

Mav

[settu_periasamy · Accepted solution]

Hi,

Try this..

Expression for Difference against total average :  =Avg(TOTAL [Avg Score])-[Avg Score]

Expression for Above / Below : =if([Difference against total average]<=0,'Below','Above')

Check the Attachment

[#3]

You can reference the existing expression names in the new expression in the straight table.

So you can use the expressions suggested by settu.periyasamy‌