Help with Dynamic Colors/Text Box

[#1]

So I have the following expression.

=num(sum({$<skill_type_id = {1},question_is_active = {1},answer_score = {0,1},topic_id = {6}>}answer_score)

/(count({$<skill_type_id = {1}, question_is_active = {1}, topic_id = {6}>}answer_id)-

count({$<skill_type_id = {1},topic_id ={6}, question_is_active = {1},answer_score = {'-1'}>}answer_score))

*100

,'##.#')&'%'

I want to the active text to be colored red when the number is <30,

30 < Black < 60,

> 60 Green

I'm having alot of trouble syntax wise getting the coloring to work. I've tried turning the above expression into a variable. Getting rid of the percentage change etc. but no luck.

Any thoughts?

Thanks!

[fred_s]

Hi Patrick,

1. Add a label to your expression

2. Click on the Plus sign at the left

3. Click on Text Color

If (Labelname < 30, red(), black())

Grtz. Fred

[maxgro]

if (label < 30, red(),   

if (label < 60, black(), 

green() ))

[#4]

Thanks it was that simple

[fred_s]

Hi Patrick,

If your question is answered, please mark it as answered.

Means also that people who are trying to help others,

don't have to put energy in this thread any more 😉

Thanks