Reference expression label on another expression

[nkosinde13]

Hi, I have two expressions that I created on a straight table and named them Actual and Core Product. So now for my 3rd expression (TA%) I want use just the label names i.e. = [Actual] / [Core Product] but I'm getting an error. I've attached a screenshot showing the error.

Is there any setting that maybe I need to do? Thanks

[dapostolopoylos]

Sometimes the expression editor returns errors but the expression works as it should.

Have you tried to evaluate the expression,  what do you see in your chart?

You can try a workaround which is much safer. If the Actual expression is the first expression in your chart and the Core Product the second then you can define the TA% expression like this:

Column(1)/Column(2)

[nkosinde13]

Hi Dimitrios, yes thank you very much. Your solution works perfectly.

[raviityou]

you can use `Expression Name`/ `Expression Name` or Column(1)/Column(2) both will work but prefer to use expression.