Hello,
Looking for the best expression to cover the following:
Looking at Variance in Claims from one year to the next. I want the higher positive numbers to show red, with the colors going towards white as they get smaller. Conversely, I want the negative numbers as they get smaller, to get more blue. Currently, my equation is:
If(Variance>0, LightRed(),
If(Variance<=0, Blue(),))
Any ideas on the best equation to get the smallest numbers to come in the most blue?
Here is my map currently:
New York and the white states should be the darkest blue possible.
Thank you!