Calculate 10th Percentile

Wed, 08 May 2013 14:59:32 GMT

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

Re: Calculate 10th Percentile

sbaldwin — Thu, 09 May 2013 10:36:53 GMT

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

Thanks

Steve