Hi

Following on from R.P.Rozema's post I have attached a copy of the data I'm working with.

Also below is my original query based on the attached dataset.

R.P.Rozema is correct...

Thanks for your speedy reply.

I've tried to be clever ( i should know better by now, not to go for shortcuts) and give you sample data, when perhaps i should...

could you not use the ICD10 and or OPCS codes. I'm presuming you work in a Hosp.

Thanks

Hi, I back and and I think I'm 95 percentile there. (excuse the pun!!!):-)

I have needed to replicate the percentile function in EXCEL which uses interpolation which gives slightly different...

Ignore my reference to median ( i was thinking about another query i'm struggling with )

I need to get the 95th percentile for each months figures.

Thanks

struggling with this one now.

I have taken the script supllied earlier in thread and added some month_names to the figures in the test data.

I have also removed the declaring of...

Thanks to Davin21 (and everyone elses comments) That seems to work fine.

I need now to add group the result by a month and/or field.

I am a bit unsure as...

Thank you all for your replies.

I now have the definition from which i am expected to work to.

"The 95th pecentile is taken as the value at position "0.95 x(number...

OK, perhaps my sample data wasnt the best example I could have used. I found this which i think may help.

"The algorithm is as follows: collect all the data...

cribbed this from another web page but feel that it explains it fairly well.

"Basically the 95th percentile says that 95% of the time, the usage is below this amount. Conversely...

Many Thanks

Many, Many Thanks

Works a treat.

My mistake, I have put the wrong date in the expected reuslts.

should read as follows.

your solution does the job but i need to exclude any rows where the datediff...

Many Thanks. All sorted now.

Dont ask about the key, we're linking to a very old system and thats the key it uses. it is a one off job so performance...

Many Thanks to everyone