color by expression in maps

[#1]

Hi, Community.

Am having a problem color coding my maps. Here's a sample table:

areacode	magnitude	proportion
1001	20	.2
1002	25	.25
1003	15	.15
1004	10	.1
1005	30	.3

I would like the the map to color polygons whose values are less than the average of proportion red and those equal and greater than the average proportion green. This expression in color by expression does not work.

     If (proportion < Avg(proportion), Red(), Green())

It just shows all the polygons in green.

My map and this table are linked by areacode.

Hope you could help me make this work.

Thanks!

[#2 · Accepted solution]

Try this,

If (proportion < Avg( Total proportion), Red(), Green())

[robert_mika]

[#4]

Thank you so much! It worked.

I assume the same goes with Min and Max?

[#5]

Thanks so much, Robert. Yes, this worked. But I could only mark one post as the correct answer.

Many thanks for your response.

[#6]

Yes, it is.