Caculated variable not showing in chart...

[#1]

The following will work in a textbox:

=$(='v'&'KPI_01_01_RAG')

And this will work in a chart expression:

='v' &

[KPI_Details] & '_RAG'

However,

=$(='v'& [KPI_Details] & '_RAG'

in a chart expression doesn't work.

Any ideas?

Stewart

[#2]

Simple and easy way forward. Excellent

Unfortunately, I an using resursion in a chart to generate the KPI indicators which will be a massive pain to replicate in the script.

Thanks for the help guys.

Stewart

PS My first time on forum - can two answers be correct?

[Peter_Cammaert]

No they can't.

Pick whatever you like the most, you can always change the assignment later on. Or assign a Correct and a Helpful answer. People shouldn't focus that much on rewards anyway... It's the glory of providing good feedback that counts

[#4]

OK.

Looks like i'm in a chilled forum. Sounds good to me.

Thanks all