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

    Set Analysis with calculation

    Goutham Kandukuri


      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.