2 Replies Latest reply: Jun 21, 2013 7:51 PM by Srikanth P RSS

    Min value over the aggregation

    Srikanth P

      Hi All, I am trying to calculate the min value of the DPML (one of field) is greater than the or equal to the FRACTILE(DPML,0.75) value for that RPT_DAY.

       

      I attached the qvw with sample data. Here below is looking for:

       

      MIN(IF(DPML>=FRACTILE(DPML,0.95),DPML,FRACTILE(DPML,0.75)))