Hi Guys, I am facing a trouble that:1 String values can’t be summarized due to datatype issues; If I did convert the column of String values into int32, then I couldn’t sumup the numeric values unfortunately. So can anyone help take a look at my flowchart, and tell me where I made mistakes? Tha…

Hello there, You do have an option while building datatable ,it would’ve been easier if you change your data type to int while building. Convert.ToInt32(dtAllRows.Compute(“Sum(Cost)”,String.Empty)) [datattype] However if its already in string type you could try this out: dtAllRows.AsEnumerable(…

Hi @Phil_Wu , A single activity will do the convert the type and do the sump. Check it below. [image] BalaReva.DataTable.Activities Community Feed Hi Friends. I have included some activities in the package of BalaReva.Datatable.Activities You can see in the below names…

Hi I tried below method, also with your attached xmal there is error , how did u solve this. can you please to resolve **dtAllRows.AsEnumerable().Sum(x =>Convert.ToInt32(x[“Cost”]))

How to sumup String values in a datatable

Help

balupad14 (Balamurugan (BalaReva)) May 23, 2018, 12:38pm 4

Hi @Phil_Wu,
A single activity will do the convert the type and do the sump. Check it below.

Regards
Balamurugan

How to sum all values in a column of an excel/Datatable?

Topic		Replies	Views
Sum rows from DataTable Business Orchestration and Automation activities , studio	8	156	June 5, 2025
Tally Amount Column / Convert column strings to Decimal Help datatable	2	1545	September 13, 2019
Convert column values datatype into string Activities excel , activities , question	2	2356	October 28, 2022
How to sum all values in a column of an excel/Datatable? Help datatable , excel , activities	63	51366	June 24, 2022
Sum Datatable using Activity DataTable Manipulation Activities excel , activities , question	4	982	June 23, 2021

How to sumup String values in a datatable

Related topics