Resolution: Not a Bug
Affects Version/s: 8.3.0 GA, 184.108.40.206 GA, 9.1.0 GA, 220.127.116.11 GA
Fix Version/s: Backlog
We are using Univariate Statistics step to calculate Percentile and it is giving wrong results.
The following formula are used to calculate the percentile.
n: Number of data.
P: Value set to "Percentile".
If the result of the calculation contains a value that is less than or equal to the decimal point, the following calculation is also used.
K th value + Decimal([K+1 th value] - [K th value])
The value of K is 150.
But, PDI is generating wrong result as 150.5
The text file is output as follows.
The text file was output as follows.