Variance color coding on the dashboard

Hi,

We have the dashboard consists of 3 columns

A,B and variance

Now I want to highlight the third column with same color irrespective + and - ve values (tried with conditional formatting, same color option is not available to highlight +ve and -ve values in same color- Red color).

Please suggest.

Thanks

Usha

Accepted answers

All comments

SandeepB

Hi @usha.cherukuri,

You can try something like this,

con 2.PNG

Hope it helps.

Thanks,

Sandeep

kavinkumar

HI @usha.cherukuri,

You can rather create a new line item (number formatted) and make the applies to none (To reduce size), then put 1 in the formula bar. Now use this line item to conditional format the 'Variance' line item.

Variance color coding on the dashboard.PNG

I hope this helps!

Regards,

Kavin.

bram.kurstjens

Hi Usha,

In addition to the earlier responses, if you only want to color when the variance is above a certain treshold, then you could use the ABS (absolute) function on your variance value instead of just inputting 1, e.g:

IF ABS(Variance) > 10 THEN 1 ELSE 0

or if you want the color scales, you could ofcourse simply use:
ABS(Variance)

usha.cherukuri

Hi @kavinkumar,

Tried with suggested solution provided, and it worked as expected.

Thank you for timely response.

Thanks,

Usha

Quick Links

Can you help?

Unanswered questions

Can Please explain the difference between a general list,a module,and action in Anaplan.
Can please explain why we create a general list ,a module,and Action ,and what purpose each one serves.🙂
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…