Changing the character and the colour if a statement is true

[brunolelli87]

Dears,

How can I change the text and it's colour if a statement is true?
Basically, I'm trying to use a if statement to show a Green Arrow Up or a Red Arrow Down... how can I do it?

Check what I'm trying to do

=if([TodayClosing]>[YesterdayClosing],chr(9650) and rgb(115,196,173), chr(9660) and rgb(207,110,131))

The formula is ok for 1 condition if true or false, but it's nor working with the AND statement.
How can I fix it?

Thanks

[HirisH_V7 · Accepted solution]

It will be something like this, as Example

Here i have used two expressions,

One in main expression:

=Sum(Revenue)& ' ' & if(sum(Revenue) < num(1000),chr(8595), 
if(sum(Revenue) >= num(1000),chr(8593)))

Text  Color Expression:

=if(sum(Revenue) < num(1000),RGB(255,0,0), 
if(sum(Revenue) >= num(1000),RGB(0,255,0)))

Attached is the QV for Ref.