Percentile calculation for every month

[amars]

Hi everybody,

I have a database, in which I need to calculate the Percentile for every month's end date. I don't know how to do that. Please suggest how to do that?

Thanks in advance.

[#2]

Hi Amar,

Calculate day's up to last day of every month. Then apply calculation.

[amars]

Fractile(Value, 0.95) in a group by clause did the thing.

Thanks.