6 Replies Latest reply: Jul 30, 2016 10:39 AM by Anil Babu Samineni RSS

    Set Analysis with calculation

    Goutham Kandukuri

      Hi,

      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.