Variable in expression.....

[#1]

The following works in a text box

=

$(='v'&'KPI_01_01_RAG')

And the following works within a chart

='v'&

[KPI_Details] & '_RAG'

But they do not work together in a chart:

=

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

What am I missing?

[yura_ratu]

Hi

Try to use some function for [KPI_Details] field. For instance

$(='v'& MinString([KPI_Details) & '_RAG')

or any other suitable

[sunny_talwar]

This issue seems to have been already resolved, isn't it?

Caculated variable not showing in chart...

[#4]

Correct - I was just looking to figure out how to delete a duplicate post....

[sunny_talwar]

Delete it or you can do an assumed answer to close this thread .

Best,

Sunny