Interested to Buy Any Domain ? << Click Here >> for more details...
How to create percentile function?
- 1 Answers
- 169 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is tablix?
What are cascading parameters in ssrs reports?
What are the different kinds of ssrs reports?
List out what other servers you can use with ssrs?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is report subscription?
Explain SSRS Architecture?
what are the different stages of Report Processing?
Which language rdl files made of?
What are the export options of ssrs?
What are drillthrough reports?
How would you go about developing a ssrs report?
SSRS SQL Server Reporting Services 
