Calculate a Percentile

[Connonymous]

I am hoping to calculate a percentile in a calculated field, but am not able to make that work. To illustrate, if I had the 5 data points below, the 60th percentile would be 2718:

1. 4364
2. 1198
3. 2937
4. 2572
5. 1682

When using percentile calculations that I see cited from other SQL platforms, I am seeing the following syntax, but this doesn't seem to work for me within Caspio. Any ideas? In the example below, "amount" would be my field name, and "sales" would be my table name.

SELECT PERCENTILE_CONT(0.60) WITHIN GROUP (ORDER BY amount)
FROM sales
 

[CoopperBackpack]

Hello @Connonymous,

I am afraid the PERCENTILE_CONT() function is not supported on DataPages. 

The logic behind this function is rather complex so I don`t see a workaround to rewrite the logic by using other functions.

It is possible to calculate the 50th Percentile which is Median. 

[Connonymous]

@CoopperBackpack okay, thank you for letting me know! 

[NailDyanC]

Hello, just to add in the previous comments above. you may check Caspio's Function Reference to see the different functions that you can use in your calculations: https://howto.caspio.com/function-reference/