Change bar colour based on the conditional measures

[Anonymous]

Hi, I'm trying to colour the measure using epression

Exp: if(sum([crudedaily]) > Sum([crudeplan]), Sum([crudedaily])='green',Sum([crudeplan])= red())
But the colour not come out, is it my expresion wrong?
What I want is if the sum of crude daily > sum of crude plan , the bar colour is green , else, red.

[shraddha_g]

Expression should be,

if(sum([crudedaily]) > Sum([crudeplan]), green(),red())

[shraddha_g]

Also please share sample app to test

[Anonymous]

This expression didn't work out,

What I want is the measure for crude daily is green, and crude plan is red

[Anonymous]

how to insert qvf file?

[shraddha_g]

Uploading a Sample

[shraddha_g]

Share this sample file if possible to test some expressions

[Anonymous]

Hi i have sent the file