20220708 Pikairos Calculate percentage by column

The -Math Formula (Multi column)- node can be a possible solution to calculate % values per numeric column as explained in this workflow.

To calculate the percentage values per column, I'm using here the following command:

```
$$CURRENT_COLUMN$$ / COL_MAX($$CURRENT_COLUMN$$) * 100
```

The node gives the option to replace the values of the selected columns or to append newly created columns with a suffix name as it is the case in my example where I add a "%" symbol to the original column names.

External resources

• Calculate percentage by column