4 Replies Latest reply on Aug 26, 2016 5:34 AM by Mark Fraser

    Percentile function missing in field calculation

    siyang.teo

      Hi, I am curious why the Percentile function is missing in the field calculation.

       

      Are the availability of functions determined by the datasource type? It was available when I am connected to MS Excel.

       

      However, when I change the database to vertica, only RANK_PERCENTILE & WINDOW_PERCENTILE are available.

       

      And since the percentile function is not there, are there any substitutes for it?

       

      Thanks!

       

      Untitled.jpg