Summarize tool

aparna0208

Hi,

I'm trying to get the sum of the value column indicated in below table. It's a string field but I used select tool and converted the data type to int and then used summarize tool to get the sum of that column. I'm not getting the output as expected. Is there anything that I'm doing wrong?

When I try to add the value column using summarize tool, the output is 29,28,25. But the output I want is(29,065 + 28,843 + 25,070)

Date	Inspection	Value
11/11/2020	Firm CRD validated	29,065
11/11/2020	Discovery Data Firm CRD/Branch ID validated	28,843
11/11/2020	Firm CRD & CRD Number mismatch validated	25,070

Raj_Singh1

hi @aparna0208 

please see solution, you need parse tool to remove ','

let me know if resolves your issue and is acceptable solution?

happy to assist further 

thanks

summar tool.yxmd