cancel
Showing results for 
Search instead for 
Did you mean: 

unexpected N\A from PERCENTILE function

bminehart
10 - ETL
10 - ETL

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?

2 REPLIES 2

jenklein
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

bminehart
10 - ETL
10 - ETL

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