Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
cesarbadill8
Contributor III
Contributor III

Expressions colors

Hi all, I am trying to create an expression to show me the negative values in red and the positive values in blue, this is the expression I am sending:

cesarbadill8_0-1664550882290.png

But I see that it takes me positive values in red, thank you very much, I appreciate your help.

cesarbadill8_1-1664550942083.png

 

 

Labels (4)
2 Replies
sidhiq91
Specialist II
Specialist II

@cesarbadill8 Can I know why is it sum(MesM='01')>='0'?  what does this expression do?

Your expression should be

if(sum(MesM='01')>='0',Blue(), red())

Let me know if you have any questions.

deepanshuSh
Creator III
Creator III

Don't you think it should be set expression here;

 

Sum({<Mesm={'01'}>}MesM) if its on front end 

 

Trial and error is the key to get unexpected results.