Forum Discussion

Petr_Durana's avatar
Petr_Durana
Frequent Visitor
2 years ago

Percentile over average value

I have table PLAYERS and in it columns YEAR, LEAGUE, PLAYER and %3P. I have slickry over YEAR and LEAGUE columns. I have a visual type table in which the PLAYER and %3P columns are the average valu...
Need Help
Petr_Durana's avatar
Petr_Durana
Frequent Visitor
2 years ago

Chyba "The PERCENTILE.INC function accepts only a reference to a column as argument number 1."

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Petr_Durana ,

 

As far as I know, the Percentile.INC function doesn't directly support measure because measure is not a static column.

 

As a workaround, consider using calculated columns instead of measures under the Percentile.inc function.

 

Best regards,

Joyce