using an existing expression in building a new expression

[#1]

hi,

i have an income column and an outcome column, and i wand to build a revenue column based on the first two fields (income-outcome).

how can use an existing expression (income and outcome) in the creation of the new expression (revenue)?

thanks.

Yaron.

[maksim_senin · Accepted solution]

Hi,

There are three ways:

1. You can use the column labels

2. You can use Column(N) function where N is a number of a column

3. You can use variable with $ expansion, e.g, $(vMyExpression1) and $(vMyExpression2) where, say vMyExpression1 = Sum(Income) and vMyExpression2 = Sum(Outcome)

Best regards,

Maxim

[tresesco]

You can directly refer them using Column() like:

Column(1)+Column(2)...

Or, using the label of the expression similarly

[amit_saini]

Yaron,

Please see the attachment.

Thanks,

AS

[avinashelite]

Hi Yaron,

You can directly you the first to expression name and the build the 3rd expression but this works only with in the same chart  .

Try like this:

[Label of 1st expression ]-[Label of 2nd expression] in your case

[income]-[outcome]