4 Replies Latest reply on Oct 3, 2016 5:53 AM by Luciano Vasconcelos

# Conditional Formatting/ KPI

Hi,

Below is a KPI I created showing quarter on quarter changes, where increase in figures adopt a purple text  and an and orange text and an for decrease, however, the downward arrow also appears when the figure shows no change, as highlighted below. I want to add a further condition showing no change, with a different colout and an ▶. The formula used for the above is listed below;

if INDEX () = 1 then

""

ELSE

if sum([HC & FTE Breakdown]) >= Lookup (sum([HC & FTE Breakdown]), -1) then

""

ELSE

""

END

END

• ###### 1. Re: Conditional Formatting/ KPI

Hi.

Probably your calculation is being done in wrong direction but i can't be sure just looking.

Can you post a twbx?

• ###### 2. Re: Conditional Formatting/ KPI

I run a test and it worked.

• ###### 3. Re: Conditional Formatting/ KPI

What does the formula look like that you used?

• ###### 4. Re: Conditional Formatting/ KPI

It's almost the same of yours:

if INDEX () = 1 then

""

ELSE

if sum([HC & FTE Breakdown]) >= Lookup (sum([HC & FTE Breakdown]), -1) then

""

ELSE

""

END

END

I just forced an equal value replacing if sum([HC & FTE Breakdown]) >= Lookup (sum([HC & FTE Breakdown]), -1) then

by:

if avg([Number of Records]) = Lookup (avg([Number of Records]), -1) then "====="