I need to perform a number of calculations. The first part is to find the sum of a particular column and then divide the sum by it's single value in the row.
LiabilityBal / Sum of LiabilityBal.
I've created a data grid with some test data, and used a group by step to perform the aggregation. This performs the calculation I need.
I've tried splitting the streams and using a lookup on the id, but that only matches one row.
This is the result I get, Ideally I would like to have the sum on each row. The sum field on row 1 is the sum of all of the fields in the second column.
Is there a way for me to put the sum back into data stream where the sum appears on each row, so that I can then perform the calculation?
Thanks for your time