I have just started work with UIPath and have some issues.
can you please help me to understand how to develop the follow code in UI Path for DataTable:
select client_number, Currency, Start_Date, End_Date, sum(Amount) as sum_amount, sum(Commision) as commision
group by client_number, Currency, Start_Date, End_Date
The excel example is attached.
Thank you very much in advance!
DimaUntitled.xlsx (10.8 KB)
It may help you.
Thank you very much. It works. Sorry for late reply
How can you sum the values of a column without using balareva.datatable.activities ?
Try below code
Amount is the name of the column that i am searching values to sum?
Yes “Amount” is column name from the datatable which you want to sum
DataTableName is as System.Data.Datatable
sum = DataTableName.Compute(“Sum(Amount)”, string.Empty) where sum is defined as int32
sum= Convert.ToInt32(DataTableName. Compute("SUM(Amount)", string.Empty))
Returns this error: Assign : Invalid usage of aggregate function Sum() and Type: Object.
Ok try below code
How do you have declared the variable that is storing the code? Since I’m not getting AsEnumerable
hi fellow, it seems this activity only can group and sum of on colunms, is it works while group multiple columns?