IF EXPRESSION

[solomonadjei]

Happy New year everyone, I hope everyone had a good time.

Could someone please advise what am I doing wrong in the below expression.

if([Trust Spend] = "Actual Trust Spend",Green(), Red())

The “Actual Trust Spend” is a label not a field name and I keep getting : RGB(0,128,0) as an answer.  

[MohammedMustaq]

Happy New Year dear!

Try with Single Quotes instead of Double " "

=if([Trust Spend] = 'Actual Trust Spend',Green(), Red())

Regards

Mustaq

[solomonadjei]

Thanks for your rapid respond Mustaq.
Still not working 😞

[MohammedMustaq]

Can you attach the sample data with your desired output.

it would  be easy to understand and solve.

Regards

Mustaq

[solomonadjei]

Hi Mustag,
I have attached image of the view.

[bgerchikov]

If  Actual Trust Spend is a column label, same as Trust Spend. Should be like this:

if([Trust Spend] = [Actual Trust Spend],Green(), Red())

Good luck!

[solomonadjei]

Thanks for your input

The [Actual trust spend] is a label name in the chart properties and am not getting the result am looking for.

[sunny_talwar]

What are you hoping to see here? You have used a color expression as a main expression.... So, because Trust Spend <> Actual Trust Spend... you are seeing the RGB() representation of Red(). What are you looking to get?

[solomonadjei]

Morning Sunny,
Am hoping to see if any number in the [Actual Trust Spend] field does not match with the Trust Spend should turn RED and a direct match should turn GREEN. The issue I have here is that, the [Actual Trust Spend] is not a field name in the table, it’s just a label name in the chart properties tab. Is there a way o can achieve this ?
Thanks

[sunny_talwar · Accepted solution]

You sure can, but what you need to do is to use your expression as a background color expression and not just the main expression. Does that make sense?