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

    Percentile function missing in field calculation


      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?