3 Replies Latest reply on May 23, 2016 9:13 AM by JayC

# Color the Up/down arrow to Green/red based on YoY%

Hi All,

How can i have the arrows (displayed below) color coded to orange/green.

I have attached the file.

Ps: I am not looking to get the arrows displayed in Tooltip.

• ###### 1. Re: Color the Up/down arrow showing incr/decr growth

Below is the screenshot .Is this what your looking for.?

You need to create a calculation if % difference > 0 then "Up" elseif % difference < 0 then  "down" .

and drag them to shape .

Regards,

Alvino Vaz

2 of 2 people found this helpful
• ###### 2. Re: Color the Up/down arrow to Green/red based on YoY%

Hi Jayachandra Yinti,

Attached is the workbook with the calculated field and Arrow colour coded. You need to make this calculated field and drag it to shapes.

"

if (ZN(SUM([Sales (copy)])) - LOOKUP(ZN(SUM([Sales (copy)])), -1)) / ABS(LOOKUP(ZN(SUM([Sales (copy)])), -1))>0 THEN "UP"

ELSEIF  (ZN(SUM([Sales (copy)])) - LOOKUP(ZN(SUM([Sales (copy)])), -1)) / ABS(LOOKUP(ZN(SUM([Sales (copy)])), -1))<0 THEN "DOWN"

ELSEIF  (ZN(SUM([Sales (copy)])) - LOOKUP(ZN(SUM([Sales (copy)])), -1)) / ABS(LOOKUP(ZN(SUM([Sales (copy)])), -1))=0 THEN "NULL"

END

"

Hope it helps you.

2 of 2 people found this helpful
• ###### 3. Re: Color the Up/down arrow showing incr/decr growth

Tq very much