3 Replies Latest reply on Jan 12, 2016 2:35 PM by Norbert Maijoor

# Performance based conditional formatting

I need to do some conditional formatting on multiple measures within the same view.  The formatting needs to be done on a performance based scale.  When the performance goals are met or exceeded, the cell's text would be green,

if 80%-99% of the goal is met, the cell is black,

and if less than 80% of the goal is met, the text is red.

I have the performance goals in a table that is linked to the report.  I'm thinking that a calculated field for this would look similar to the one below, but I could be way off.

Extsub T = the goal

Suggestions?

IF SUM([EXT_SO])<(0.8*(SUM([Extsub T]))) Then 'Red'

ELSEIF SUM([EXT_SO])>=(0.8*(SUM([Extsub T]))) Then 'Green'

END

• ###### 1. Re: Performance based conditional formatting

Mickey

Find my approach below and stored in attached workbook version 9.0

IF SUM([EXT_SO])=1*(SUM([Extsub T])) Then 'Green'

ELSEIF SUM([EXT_SO])<=(0.99*(SUM([Extsub T]))) and SUM([EXT_SO])>=(0.8*(SUM([Extsub T]))) Then 'Black'

ELSEIF SUM([EXT_SO])<(0.8*(SUM([Extsub T]))) Then 'Red'

END

• ###### 2. Re: Performance based conditional formatting

Thank you Norbert.  Unfortunately, I'm still coming up with the same results.  Everything is showing up as red no matter the level of performance.

• ###### 3. Re: Performance based conditional formatting

Mickey,

Could you share your workbook in version 9.0 or higher?