Create calculated column based on formula in other column

[Anh_Nguyen]

Hello,

I have a sample table below:

ID	Formula	Date	Value
A	[Value]+3	1/1/2023	15
B	[Value]*2	1/1/2023	16
A	[Value]+3	2/1/2023	12

Can I create new calculated column based on formula in Formula column? The result table maybe like sample below

ID	Formula	Date	Value	Result
A	[Value]+3	1/1/2023	15	18
B	[Value]*2	1/1/2023	16	32
A	[Value]+3	2/1/2023	12	15

Any help would be appreciated

[slorin · Accepted solution]

Hi,

new column "Result"

Expression.Evaluate("each "&[Formula])(_)

Stéphane

[Anh_Nguyen]

It worked! Thank you very much for your help.