How to refer to an expression in another expression

[#1]

Hi All,

I apologise if this is a very simple question, but I cannot find what I'm looking for, partially because I'm not sure what to search for...

In a straight table I have several expressions where their definitions are fairy complex (well for me anyway), I want to be able to refer to these expressions within other expressions, for example:

Expression 1 = profit year 2010
Expression 2 = profit year 2011
Expression 3 = profit difference between 2010 and 2011 expressed as a percentage

Although I can generate expression 3, it is based on expressions 1 and 2, which are already quite long in themselves.  What I would really like to be able to do is refer to the expressions via an alias or something similar.  This would make expression 3's definition easier to read, and if I have to change expression 1 or 2, this would be automatically reflected in expression 3.

I hope this makes sense, and if possible, will save me a great deal of time and banging my head against a brick wall.

Thanks in advance.

Trevor

[kaushiknsolanki]

Hi,

     You can refer to already defined expression in chart by their label.

     Just type the expression 3 as [profit year 2010] - [profit year 2011]

Regards,

Kaushik Solanki

[jagan · Accepted solution]

Hi,

You can also use

=Column(ExpressionNumber)

Just type the expression 3 as Column(1) - Column(2)

in your expression.

Regards,

Jagan.

[#4]

I had wondered about this, but the column caption is based on a variable which is populed by a user selection, so wasn't sure if this would work?  Plus would still be a little bit more complidated to read - well for me anyway!

Thanks for the quick response!

[#5]

This works like a charm and makes life so much easier for me - this is going to save me a lot of effort!

Thanks

Trevor