I have a data table that is getting entries from a commission report into the 5th column, the data type is “string” on the build data table because the source value includes decimals “115.35” for example, I have a for each that reads a report and places the commission value in the dt. I then need to…

SumOfReportTotal variable is of Integer type. That is why it is showing the error. It should be of Double type.

Unable to sum value in data table

Nathan_Betters1 (Nathan Betters) October 10, 2022, 2:26pm 3

I tried cdbl and it tells me that conversions are disallowed

Topic		Replies	Views
Conversion from string to type 'Double' is not valid Studio datatable , excel , uiautomation , orchestrator , activities , studio , question , activities_panel	10	1923	May 27, 2023
Tally Amount Column / Convert column strings to Decimal Help datatable	2	1521	September 13, 2019
Sum Of a column from a Data Table without Loop Studio studio , question , variables_management	11	97	November 22, 2024
Add columns of double type in datatable Studio studio , question , find_references	2	1044	March 19, 2021
String to double, Studio studio , question , tools	11	611	April 23, 2023