I'm trying to color code by expression on a map and it's not working ... I believe the calculation to be correct, can anyone help with this? I can send you additional information if needed. Thanks!
if (Sum([Shrink Dollars])/Sum(Dollars)>3,rgb(102,37,6),
if (Sum([Shrink Dollars])/Sum(Dollars)>2.5,rgb(153,52,4),
if (Sum([Shrink Dollars])/Sum(Dollars)>2,rgb(204,76,2),
if (Sum([Shrink Dollars])/Sum(Dollars)>1.5,rgb(236,112,20),
if (Sum([Shrink Dollars])/Sum(Dollars)>1,rgb(251,154,41),
if (Sum([Shrink Dollars])/Sum(Dollars)>.5,rgb(254,196,79),
if (Sum([Shrink Dollars])/Sum(Dollars)<.5,rgb(254,227,145))))))))
Hi Erin, you can try creating a table with the field used as map dimension and the expression:
Sum([Shrink Dollars])/Sum(Dollars)
And confirm the values returned are as expected, you can also try setting the color codes between simple quotes to confirm the color code value returned is also correct:
if (Sum([Shrink Dollars])/Sum(Dollars)>3,'rgb(102,37,6)',
....
If it seems ok in table maybe is something realted with map settings, a sample will be nice to confirm why is not working.
