How do I calculated what's in the 99.97% percentiles ?

[KerryWang]

Hi all, 

I've search the community and see most posts for calculating are using Macro, however, I have trouble downloading it. I was wondering if I could formula tool to get the 99.97% percentiles or any custom number of percentiles. I also don't understand how the percentiles works in the summarized tool, it doesn't see to allow any input, and the output make sense for me.

I am dealing with 1.5Mil row of data. In excel, I could use Percentile.ext function, but i couldn't figure out how to use this in Alteryx. 

thank you for your help in advance!

Example: With the following data, I got $99754 is the 99.97% percentile by using the excel formula.

Data
-200.00
2.00
30.00
99997.00
10000.00
0.00
7.00
100.00
20.00
10.00

[DataNath · Accepted solution]

Is this what you're after? Returns the same result as your excel function did. The input is down in the text box in the bottom left.

[KerryWang]

Thank you so much! This is exactly what I am looking for!