topic Re: Trouble with color coding by expression on map in App Development

Trouble with color coding by expression on map

Anonymous — Mon, 11 Dec 2017 20:46:05 GMT

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))))))))

Re: Trouble with color coding by expression on map

MK9885 — Thu, 21 Dec 2017 19:04:35 GMT

can you upload sample app if possible?

Re: Trouble with color coding by expression on map

rubenmarin — Thu, 21 Dec 2017 20:01:32 GMT

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.