I have a table with column “Cycle”,“value” ,“type” and “media”. I need to sum up the value of the same cycle if the type and media is of certain values.
E.g
Cycle|value|type|Media
1 | 123 | A | Air
1 | 132 | B | Water
1 | 234 | A | Air
2 | 122 | A | Solid
2 | 453 | B | Air
2 | 123 | A | Air
In this case, row 1 and 3 has the same type and media and cycle so i need to sum the value together.
Filter table activity can filter the “type” and “media” but if i were to filter cycle too, i have to repeat a lot of times as there are a total of 26 cycles.
Is there a way to better sum the values of the same cycle together after filtering?
@Shashi123 I’m sorry but i need a little more details, new to uipath and now experienced in excel. How do i apply that formula on uipath to write the datatable to new sheet?
@supermanPunch
The rows with conditions C & 2,3,4 (E.g row 9-11) and A 2,3,4 (E.g row 3 (A+2) ) are to sum together. The filtering would be something like