Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have an expression where I want to add some text I.e 'Hello'
Can someone help me write the expression please, as the below is not working:
=
if(CWT_Monthly_desc.desc_2 = '01 All Cancer Two Week Waits', (sum({<CWT_Monthly_desc.desc_2 = {'01 All Cancer Two Week Waits'}>} CWT_Monthly_desc.Desc_within_time )/ sum({<CWT_Monthly_desc.desc_2 = {'01 All Cancer Two Week Waits'}>} CWT_Monthly_desc.Desc_total)*100) & 'Hello ' &
)
Thanks
Helen
remove the last &
Hello
Thank you for your response
I
have now put:
=
if(CWT_Monthly_desc.desc_2 = '01 All Cancer Two Week Waits', (sum({<CWT_Monthly_desc.desc_2 = {'01 All Cancer Two Week Waits'}>} CWT_Monthly_desc.Desc_within_time )/ sum({<CWT_Monthly_desc.desc_2 = {'01 All Cancer Two Week Waits'}>} CWT_Monthly_desc.Desc_total
)*100) & 'Hello '
and the text does not show in my graph. I am working with a nested if statement and the % or "Hello" will be shown in chart on the right axis
Do you
have any further suggestions?