Value Change shows as the opposite pos/neg in multiple value visualization

[hbsmfrterofr86]

I'm using multiple values to view the change in percent and dollars. The $ change always swaps the positive or negative arrow and I don't know how to fix it. 

The $1,195,185 is a positive value but the viz shows it negative with the red arrow. 

[sam8]

Interesting. It makes me wonder if the measure is actually calculating a negative value, but is displaying a positive value? I'd love to see the LookML for this measure. 

If you don't have access to the LookML, one workaround would be to toggle "positive values are bad", which you can see in your screenshot. It'd keep the minus sign, but it would at least flip the arrow and make it green.

[hbsmfrterofr86]

I solved this actually. The issue was just the number formatting and I had forgotten I'd added it from a separate look that used the numbers differently. Really easy, I updated it to this: 

[>1000000]"$"0.0,, " M";[<0]"-$"0.0, " K";"$"0.0, " K"

[sam8]

Sweet!