This content has been marked as final. Show 6 replies
I am trying to achieve some thing like
stdev(IF abs(val - Valmedian) < ( Valmedian*10), val)
i am trying to create a set expression where i can do median of the val which are less than 10% of total median
Valmedian - is total median without any selection and
Val - is actual value.
Something like a ZScore.
Can any one please advise.