Error in Expression for Text Colour

[helen_pip]

Hello

I was wondering if you could kindly help me

I have written an expression for text colour in table and am getting a syntex error:

=

if (Level3_Month='95TH CENTILE',time(Fractile({<Inline_Monthly_DataSource={ 'ED'} >} Inline_Monthly_Data_A,0.95>240), RGB(255, 0,0), Green

())

)

The error is in this part of the expression, where the comma is

RGB(255, 0,0), Green ())

Can anyone suggest changes to the script?

Many Thanks

Helen

[neha_shirsath]

Hello helen,

If you want to give color to the expression values then in Chart properties > Expression

(

if (Level3_Month='95TH CENTILE',time(Fractile({<Inline_Monthly_DataSource={ 'ED'} >}Inline_Monthly_Data_A,0.95>240)

)

>click on + sign on your expression there you get the Text color> in Definition give your RGB(255,0,0)

rather than giving color in expresiion.

[helen_pip]

Hello

Thank you for your response

I ahve written my expression under text colour as suggested, my problem is the fact that there is an error in my expression and need help rewriting my expression

Are you able to help?

Thanks

Helen

[#4 · Accepted solution]

Hello Helen,

  try this:

=

if (Level3_Month='95TH CENTILE' AND time(Fractile({<Inline_Monthly_DataSource={ 'ED'} >} Inline_Monthly_Data_A,0.95)) >240,

RGB(255, 0,0), Green()

  )

This should work but I'm not sure is if it is implementing your logic. If it is not working please try to explain your "if" condition with words.

Regards,

Daniele

[helen_pip]

Hello Daniele

Thank you this works

Thanks

Helen

[#6]

I am glad! Please mark my answer as correct so we can close this post successfully.

Thank you

Daniele