Convert decimal numbers to the sum of 100
Hi KNIME experts,
I have come across this issue today where a project contains more than one row but each row has a credit percentage of 100 as shown below and counter column is how many rows does this project have in this workflow.
I had to divide this credit percentage by Counter and this is what I got after the math column which is credit percentage is 33.333.
However the sum of this credit percentage column for a particular project must be equal to 100. This is the place where issue comes that our system accepts only up to two decimal points and when I do this I get the sum of the credit percentage as 99.99 but I need this to be 100.
What can I do to overcome this issue, could anyone help me please with this issue?
Thanks in advance.