Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to create an expression, in an expression text color, to turn different colors when certain conditions are met.
If a single record of [Expression1] is 0 then Red,
And/Or
If 2 or more records of [Expression2] are 0 then red,
If Sum([Expression1]+[expression2]+[expression3]...] >= 20 then Green
else black
I can't figure out the syntax on this one. Could someone please help?
Thanks in advance.
Brian
Can you be more specific on your current expressions? Also, the type of chart you are using?
Thanks for the reply, Nick,
The expression I want to place this text color expression into is a simple expression where it adds all of the expression ‘scores’ of the table into a total. Each expression in the table is basically an if statement for scoring system. For example if Test Score1 >=.85, 4, 0; if Test Score2 >.9,5,0…etc) The Total Score expression just adds the expressions up to a total score. The total score expression is where I need to add the text color expression.
IF(COUNT(TestScore1 = 1) AND TestScore1 > .85, Red()),
IF(COUNT(TestScore > 1) AND TestScore2 > .9, Red()),
IF(SUM([Expression1]+[Expression2]+[Expression3]) >= 20, Green()),
Black())