Min value over the aggregation

[#1]

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)))

[swuehl · Accepted solution]

Try maybe something like

=min(aggr( if(DPML >= round(Fractile(total<RPT_DATE> DPML,.75),.01),DPML),RPT_DATE,DPML))

[#3]

Thanks swuehl.