1 Reply Latest reply: May 9, 2013 6:36 AM by Steve Baldwin RSS

    Calculate 10th Percentile

    Dominic Ayling

      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