9 Replies Latest reply: Jun 12, 2013 8:08 AM by michel bardy

# column() in expression

In a table (in a graph), i have two expressions, each of them have a calculated label.

In a third expression i use a formula like "=column(1) - column(2)".

If i add a column before the first one, i'll still have "=column(1) - column(2)" in the expression of the last column and that's not what i want.

How may i reference always the same cols (with not fixed but calculated label) in the expression without taking care of the order i set them in the table.

• ###### Re: column() in expression

Sorry didnt get you

• ###### Re: column() in expression

exemple :

i have a first column with a calculated label.

in another column (i call it TOTAL) i use column(1) to reference it.

If i move the first column in second position, column(1) in TOTAL will still reference the first column of the table.

How can i reference my col so that even if i move it, the reference in TOTAL will still be ok.

(That's a probleme of calculated label i can't use to reference the col)

• ###### Re: column() in expression

Hi,

Just instead of using Column() use Expression label, so even if you change the position of the expression you don't need to change the expression.

For Example:

First Expression:

Expression Label : Total Sales

Expression : = Sum(Sales)

Second Expression:

Expression = [Total Sales] + (Some Calculation)

Hope this helps you.

Regards,

Jagan.

• ###### Re: column() in expression

My deal is : how can i do if the column has a calculated label and not a fixed one.

What i realy have in the label is :

='comptes mouv '&\$(Annee variable)

• ###### Re: column() in expression

It would be \$(='[comptes mouv ' & \$(Annee variable)]')

• ###### Re: column() in expression

\$(='[comptes mouv ' & \$(Annee variable)&']')

to be exact.

But that's it.

• ###### Re: column() in expression

Hi,

Please find attached file for solution.

Regards,

jagan.

• ###### Re: column() in expression

If the column label is calculated, u can still refer to it by name.

Let say the column name is

='Up to ' & var_delay & ' days'

In the expression u can refer to that column using syntax

\$(='[Up to ' & var_delay & ' days]')

• ###### Re: column() in expression

Perfect !!!

Hard to guess ;-)

Thank's a lot, it's a huge help.