Hi all,
I have a datatable that looks something like this: A, B, C, 1,3, 5, 8, 17 - First three columns are text, next 4 are decimals and last one is sum of columns 4 to 7.
I want to create a duplicate datatable and replace the decimal values with their percentages (value/sum), so it would look like:
A, B, C, 6%, 17%, 30%, 47% (don't care about the last since it is always 100%). Itried to clone the original, read cell values and calculate decimals and store it into new datatable but can't store 6% since it is expecting decimal in that cell.
...
Go to the complete details ...