Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / Nirpendra Rai
SSRS does not have a built-in Percentile function. However, you can calculate it by sorting the dataset in ascending order and then finding the nth value based on the number of records.nnHere's an example expression that calculates the 50th percentile (median) for a numeric field named Sales:n=IIF(CountDistinct(Fields!ProductID.Value,"DataSet1") MOD 2 = 1, Fields!Sales.Value(RowNumber("DataSet1", CountDistinct(Fields!ProductID.Value,"DataSet1") / 2)), Fields!Sales.Value(CountDistinct(Fields!ProductID.Value,"DataSet1") / 2))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
