Return the value of an expression from one column to an other.

[Anonymous]

Hello to all,
how do I find the value calculated by an expression contained in the previous column to the current one:

example:

Pivot Table:

Code	Field2 (expression)	Field3
code1234	10	calculated value of Field2 (=10)

The result of the Field2 is given by an expression (Result = 10)

My goal is not to have to return the expression in Field3 but only the result of the expression of Field2. Is there a way to do this?

Thank you all.

[MayilVahanan]

Hi

Try like this

=Column(1)

or

= [Expression Label] // Column1 expression label

[Anonymous · Accepted solution]

Manual

Give Field2(expression) a label like say

      EXP2

And then you can reference it another expression as say

      EXP2 + 10

Best Regards,     Bill

[Anonymous]

Thank you so much for your help.

Bye