3 Replies Latest reply on Oct 26, 2018 6:45 PM by Yuriy Fal

# Use different colors to indicate increase or decrease in values

Hey guys,

Been banging my head on the wall for the past 2 hours trying to figure this one out. So I have two dollar values across two time periods (Q3 2018 and 1H 2018) and I'm trying to show the direction of change using two colors. Here's where I'm at right now:

I've already tried using a calculated field to determine the difference between the two values for each category:

```SUM([Full kVA]) - LOOKUP(SUM([Full kVA]),-1)
```

When I put this on the color shelf, I get a blended color that goes from red to green or vice versa. How do I get the entire line to show in one color depending on whether the value has increased or decreased in 3Q 2018 compared to 1H 2018? Thanks for any help you can send my way.

• ###### 1. Re: Use different colors to indicate increase or decrease in values

Hi Muneeb,

On this particular view, you may want to use the following calculation in Color:

LOOKUP( SUM([Full kVA]), LAST() - LOOKUP(SUM([Full kVA]), FIRST() )

Make this Table Calc to Compute using --> [Time Period]

Hope it could help.

Yours,

Yuri

• ###### 2. Re: Use different colors to indicate increase or decrease in values

Wow! That worked. Thanks so much!!

• ###### 3. Re: Use different colors to indicate increase or decrease in values

Muneeb, you're welcome.