Summarizing Data

[abbysarno]

I'm trying to summarize data:

File #        Data

100123     10,250

100123       5,250

100124       1,750

When I use the Summarize tool, why does it only give me:

File #       Data

100123    15

100124      1

[fmvizcaino]

Hi @abbysarno ,

Since your numbers has a comma as decimal separator, when transforming to double, you need to check the box down below the select tool, as image below.

Let me know if this works for you and mark the answer as correct if I achieve your expectations, please.

Best,

Fernando V.

[abbysarno]

I updated the type to  "double" and marked the box.

It now gave me:

15.5

1.75

[fmvizcaino]

@abbysarno ,

Is it what you were looking for, right? 🙂

[abbysarno]

it should sum to:

100123  15,500.00 

100124    1,750.00 

[fmvizcaino · Accepted solution]

Hi @abbysarno ,

Attached is an example. You can also format the data after to have that same format as yours (15,500.00) but it will not be in numeric format.

Best,

Fernando V.

[abbysarno]

You are amazing! Thank you.