Comparing fields in XML with color

[tefa627]

I am trying to compare 2 fields in this xml.  I have a field named avg that I want to compare with the other columns. Below is what I have. I am trying to compare values in "00" with avg and it is not working. Any suggestions?

<format type="color" field="00">
<colorPalette type="expression">if(value &lt;= "avg", "#088D4C",if(value &gt;= 3501 AND value &lt; 6001, "#F5F405" ,"#DE0303"))</colorPalette>
</format>

tefa627_2-1605563579360.png

[ITWhisperer]

Try "avg" without the double quotes or perhaps use single quotes instead

[tefa627]

I have previously tried both. Neither works.