Colour not working with calculated field

[solomonadjei]

Could someone please tell what I am doing wrong. Based on the yellow highlighted figures, I assumed the red field figures should be green but it not.  Thanks

Colour

[jaumecf23]

You're applying the colours to the Expression and this is why the last column (Actual Trust Spend) is appearing in Red. You need to apply this formula in the Dimensions sheet to the affected dimension. 

[solomonadjei]

Thanks Jaumecf23,
I have tried it in the dimentions sheet and I get the same asnwer.

[solomonadjei]

Both left and right figures highlighted in yellow are the same and I assume the red fields should be GREEN but it’s not..

[jaumecf23]

Here you have an screenshot where you need to add your formula:

Is it possible for you to attach the qvw file? Because it should work.

[solomonadjei]

This is what I get, Maybe my expression is incorrect.

[jduenyas]

You are comparing value with text.

Change the 'Actual Trust Spend' to the name of the calculated field [Actual Trust Spend].

[solomonadjei]

Thanks Jduenyas,
I have tried your suggestion and it keeps hightlight in RE. becaused its not a field name.
It's a Label name