Color Coordinating Value on Target

[danieldors]

Hello,

Im looking to color coordinate the formula below to  green and red based on the returned value.

>.37, Green(),rgb(178,36,36))

=
(Sum({<[InterviewCompletedDate.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"}>}If(InterviewCompletedBy=[FLA ID-pas], 1, 0)))
/
(count({<[InterviewCompletedDate.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"}>}Access_Number)
+
(Count({<[InterviewCompletedDate.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"}>}CaseNum)-count({<[InterviewCompletedDate.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"}>}Access_Number)))

[morgankejerhag · Accepted solution]

I am not sure what is not working for you. In general, you can write expressions like if(some-conditional-statement, green(), rgb(178,36,36)). So if you long expression is valid and will return a value  you should be able to write if(your-long-expression > 0.37, green(), rgb(178,36,36))

Morgan Kejerhag
Senior Business Intelligence Consultant
Drake Analytics
http://www.drakeanalytics.se