calculating mean, median and standard deviation

[Sai_Mohan]

hi all, can anyone please help to write set analysis for calculating mean, median and standard deviation. i have two columns for calculation. i need to calculate using num function .

for ex:  this for calculating mean:                            

num(avg(aggr(coln1,coln2)),##.##)

same like this i need for median and standard deviation

[JordyWegman · Accepted solution]

Hi,

You can use the functions:

1. Avg()
2. Median()
3. StDev()

Jordy

Climber

[Sai_Mohan]

Thank you Jordy. Its working well now