Data table Sum

Hi All,
i have two excels, one excel has a column named “Difference”. so for each ISIN number whatever value difference columns contain i have to match it with the same ISIN number in other excel

it could present in each row or sum of all the rows and either in combination of rows. for example: sum of values in row 1 and row 2 (equal to value of difference column), row 2 and 3((equal to value of difference column), row 3 and 1 (equal to value of difference column)(if we have 3 rows after filter) basically combination

1 Like

Good morning,

TO get the total of a column, please try the solution below:

You will need to filter your datatable to contain only the rows you want to add together.

Hi @P_Singh,

This activity will help you.

Here you can set the condition for the datatable.