@Snowy provided a detailed and great response.
Is the total column already available (which would be assumed based on your screenshot) or do you need to calc it?
br
Hi @Snowy , yes I was looking at it from the calculation perspective
The column does not need to be calculated, as it will always be 100%, and it was not part of the 3 columns that @Aldwyn wanted to transform. However, I do understand why you added it, because in your example, you are replacing the original columns, and that would avoid any confusion.
I’ve put something together that does not replace the original values as it is often the case that people want to keep both the numbers and the percentage, and it is how @Aldwyn presented the expected results, although that could simply because it was done in Excel.
Hi @Aldwyn , and welcome to the Knime Community. This is how my workflow looks like:
As raised by some, may be the Total column is provided, or may be it’s not. I added a node that generates the Total column for you. If you already have the Total column, you can just remove that node.