Formula Transform for Multi-Column Calculations

Hi,

Recently, I needed to add several columns together, and while the Calculate feature does the job, repeating the process multiple times can become quite tedious.

I was wondering if it would be possible to introduce a Formula transform—a feature where users could input expressions involving multiple columns (e.g., +, -, *, /, ^, and parentheses to control evaluation order).

I realize that JavaScript can handle such cases, but it requires scripting knowledge and may incur some performance overhead. A built-in formula interface would make these tasks much more accessible and efficient for all users.

Just a suggestion—thanks for considering it!

Best regards,
Miguel

We did think about adding a Formula transform. But it would have been just a subset of the Javascript transform.

If you want to multiple column A x column B and add column C in the Javascript transform it is just:

return $(A) * $(B) + $(C);

Also the Javascript transform is surprisingly fast. Try it.

Here it is, you can do the following to make your formula transform.

Transform file.
FormulaTransform.transform (2.2 KB)

2 Likes

Thanks Andy, very illustrative,

Regards,

Miguel

Just…amazing!

Thanks,

Regards,

Miguel