create sum of column without losing all the rows

[simonius]

Hi,

I need per row a sum of the entire collection. 

The only thing I find to create a sum is with the aggregateRow. But this removes my rows. And just gives me the total. 

How can I per row convert column B from single row value to the total of all rows. I need this in every row of my selected data.

Kind regards, 

[vapukov]

Hi,

you can use tJavaFlex( or tJavaRow) between source and destination, here you just store to a variable 

as an example with tJavaFlex:

in the top section:

globalMap.put("SumTotal",0);

in the middle section:

globalMap.put("SumTotal", globalMap.get("SumTotal")+row1.ColumnB);

of course, you need to control null values