Archives of the TeradataForum

Message Posted: Mon, 08 Sep 2003 @ 16:03:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Veerenadar,

- Mean and Average should be the same

- No median function exists (however, you can get creative with the quantile function or csum(1,1) to figure this one out)

- You can use the Quantile (or Percent Rank?) OLAP Function to calculate the 90th percentile

Hope this helps,

Clay

	<Prev	Next>		<<First	<Prev	Next>	Last>>