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.