Percentile calculation

[Cloud release: 2025.01.15]
[On-prem release: 2025 January]
[On-prem build: 25.02.07520] 

Returns the threshold value according to the percentile_value in the referenced range.

Syntax:

percentile(column, row, measure, percentile_value)

Notes: percentile_value must be in the range 0..1

Example:

percentile(d-1, all, m1, 0.25)

Note: Percentile calculations may be defined in many different ways. The TARGIT Percentile function resembles the PERCENTILE.INC function in Excel.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.