Forum Discussion
Solved
Create calculated column based on formula in other column
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
Hi,
new column "Result"
Expression.Evaluate("each "&[Formula])(_)Stéphane
2 Replies
Hi,
new column "Result"
Expression.Evaluate("each "&[Formula])(_)Stéphane
It worked! Thank you very much for your help.
