Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
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
Hello Daniele
Thank you this works
Thanks
Helen
I am glad! Please mark my answer as correct so we can close this post successfully.
Thank you
Daniele