Forum Stats

  • 3,782,427 Users
  • 2,254,644 Discussions
  • 7,880,077 Comments

Discussions

Percentile calculation in OBIEE

Hi,

I am trying to calculate percentile in OBIEE, used percentile and ntile function..but not getting the desired result.

Expected ans In Red color. How to achieve this in OBIEE..????

     

DateCount of StudentCount of Student scored more than 025 % Percentile of Student Marks who scored more than 050 % Percentile75 % Percentile
01/01/2015201874794
01/01/2016201862494
01/01/2017202041190
DateStudent Marks
01/01/20150
01/01/20150
01/01/201510
01/01/201590
01/01/201511
01/01/20158
01/01/2015100
01/01/20153
01/01/20156
01/01/20152
01/01/20155
01/01/201596
01/01/201594
01/01/201547
01/01/201587
01/01/20157
01/01/201578
01/01/201556
01/01/201597
01/01/201599
01/01/201695
01/01/20160
01/01/20160
01/01/201610
01/01/201690
01/01/201611
01/01/20168
01/01/2016100
01/01/20163
01/01/20166
01/01/20162
01/01/20165
01/01/201696
01/01/201694
01/01/201624
01/01/201687
01/01/20166
01/01/201678
01/01/201656
01/01/201697
01/01/201795
01/01/20177
01/01/20176
01/01/201710
01/01/201790
01/01/201711
01/01/20178
01/01/2017100
01/01/20173
01/01/20176
01/01/20172
01/01/20175
01/01/201796
01/01/201794
01/01/201747
01/01/201787
01/01/20177
01/01/201778
01/01/201756
01/01/201797

Could you pls assist in getting solution.

Thanks,

Tagged:

Answers

This discussion has been closed.