Showing results for 
Search instead for 
Did you mean: 

unexpected N\A from PERCENTILE function

9 - Travel Pro
9 - Travel Pro

We sometimes received N\A results from a PERCENTILE calculation, even though with the same dataset we will get results from other statistical functions like AVG or MEDIAN.

I'm wondering if this has to do with a minimum number of values requires to calculate PERCENTILE? Is this defined anywhere? I don't see it in the online function reference.

Is there some other common cause for getting an N\A result for PERCENTILE?


7 - Data Storage
7 - Data Storage

hi there, has there been a response to this question? I am having a similar issue where the visualization does not materialize and am wondering if it is because the field I am using has decimal point values mixed with non decimal point values

9 - Travel Pro
9 - Travel Pro

I haven't receieved any response, @jenklein . I'd love to get it resolved!

Community Toolbox

Recommended links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]