Calculate 10th Percentile

[#1]

Hi All

I have an Expression like:

=Sum({$<Episode.Source = {'IP'},[DriversExp.ItemType]={'Expense'}>}  ServData.VolAmt*DriversExp.FCostUnit)

/

Count ( {$<Episode.Source = {'IP'}>} DISTINCT Episode.Epinum)

This gives me a unit cost, however, I want to be able to compare this with the top 10th percentile or "unit costs"

I have this against a single other dimension.

Can anyone advise?

Thanks

Dominic

[sbaldwin]

Hi, have you looked at the fractile function, this should calculate the percentile.

Thanks

Steve