Summarize Percentile Not Working

[The_Fray]

Hello,

I am having issues with the Summarize tool and percentiles. 

I want the percentiles for a column that looks like the following:

but once I run it through the summarize percentile nothing happens:

i was expecting 0 - 100 percentile, not numbers over 200 with no changes to the acutal data.

Thanks,

Fray

[Maskell_Rascal]

Hi @The_Fray - your issue is with the group by in the summarize tool. When you group by, the summarize tool applies any calculation to the those groupings. 

[The_Fray]

Hmm. I see what you are saying now. Is there a way though to get the percentile for every row in the data? for example, if the first 5 numbers in the dataset at 25, 50, 66, 75, 100, I want to know the percentile for each one of those numbers.

Thanks

[Pingu · Accepted solution]

I am not sure if its possible without using sum, otherwise you will always get 1 value.

Does this what you need?

[Maskell_Rascal]

@The_Fray - can you provide an input and expected output?