expression and label

[souadouert]

Good morning

I have a simple table, with several expressions, I have expressions whose label is an expression also.

So sometimes in the table an expression is composed by another expression.

In case the label is an expression I can not use the name of the expresion when it is expression

for example:

exp1:='Realisation ' & MAX(MONTHNUM) & '/' &(Max(YEAR)-1 ) 

exp2:='Realisation ' & MAX(MONTHNUM) & '/' &(Max(YEAR) )

exp:=exp1/exp2

Can I find a solution ?! To note the expression

[stigchel · Accepted solution]

I tried and it worked for me, something like this

[$(='Realisation ' & MAX(MONTHNUM) & '/' &(Max(YEAR)-1 ))]/

[$(='Realisation ' & MAX(MONTHNUM) & '/' &(Max(YEAR) ))]

Whether you should want that is another question, you could also use e.g. Column(1)/Column(2)

[souadouert]

hello ,

i tried yr solution and doesnt work

Otherwise I did not understand, column1 / column2

[klausskalts]

You could also use the Column(1)/Column(2) option .... if it's column 1 and 2

[souadouert]

Piet thx piet i undrstand  yr proposition (function colmn (nb)

[souadouert]

yes , i fixed the solution with the column funtion thx

[stigchel]

I may have missed a ')' , the one that closes the dollar sign expansion $(=Exp)

[souadouert]

you are right Piet thx a ')' missed