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?