Forum Discussion

bminehart's avatar
bminehart
ETL
05-15-2023

unexpected N\A from PERCENTILE function

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?

On cloud

2 Replies

Replies have been turned off for this discussion
  • jenklein's avatar
    jenklein
    Data Storage
    07-31-2023

    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