Calculate total of all values in a column and create a new column of the sum

I have data with a single column :

100
200
300
500

I want to calculate the sum of these values in second column and col1/col2 as third column. ouput is as follows:

Output
100 1100 .09
200 1100 .18
300 1100 .27
500 1100 .45

 

1 Like

You can calculate the sum using the "Group By" node, join back the sum to your input column using a "Cross Joiner" and calculare the division use a "Math Formula".

3 Likes

Thanks qqilihq. It works perfectly.