PercentileMode.Type

Definition

Specifies the percentile mode type.

Allowed values

Name	Value	Description
PercentileMode.ExcelInc	1	When interpolating values for List.Percentile, use a method compatible with Excel's PERCENTILE.INC.
PercentileMode.ExcelExc	2	When interpolating values for List.Percentile, use a method compatible with Excel's PERCENTILE.EXC.
PercentileMode.SqlDisc	3	When interpolating values for List.Percentile, use a method compatible with SQL Server's PERCENTILE_DISC.
PercentileMode.SqlCont	4	When interpolating values for List.Percentile, use a method compatible with SQL Server's PERCENTILE_CONT.

Applies to

• List functions