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