3 Replies Latest reply on Jun 30, 2016 12:49 PM by Michael Hesser

    What is wrong with my calculated field?

    Joey Bloom

      I am trying to create a field so that on my bar chart, if expenses are above (really below because they are negative) $100, they will be red. When I do this, it works except for one column. Although the "Gas" bar is clearly above (again, really below) the $100 mark at around $150, it doesn't register correctly and gives it the wrong color. I will include a picture of my chart and my calculation as well as some fake data in the same format. Most of the numbers have been changed from my original set but any row with the category being gas has been left the same as that is my problem. Thanks in advance for the help!