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 · Accepted solution]

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

[aparna0208]

@Raj_Singh1 Awesome, it worked:) Thanks a lot for all your help on this:)

[Raj_Singh1]

thanks @aparna0208 for accepting as solution