This content has been marked as final.
Show 3 replies
-
1. Re: What is wrong with my calculated field?
Tina Hauser Jun 30, 2016 12:35 PM (in response to Joey Bloom)Hi Joey,
You will need to SUM the amount, then this will work.
So your calculation would be:If sum([Amount]) < (-100) then "over 100" else "under 100" END
-
2. Re: What is wrong with my calculated field?
Hope Stiles Jun 30, 2016 12:40 PM (in response to Joey Bloom) -
3. Re: What is wrong with my calculated field?
Michael Hesser Jun 30, 2016 12:49 PM (in response to Joey Bloom)Hi Joey;
I'm gonna guess the issue here is that you're coloring by individual values when you want to aggregate it, then assign a color. Since every individual gas expenditure is <$100, it remains green.
ALSO, since you're dealing with expenditures, your aggregation should be looking for values beneath -$100.
I was able to arrive at a simple LOD calculation which did the trick for me:
Drop this in as your color and assign the colors you prefer.
Please give this a try and see if it works for you!
--Michael