19 Replies Latest reply: Apr 28, 2016 4:24 PM by Sunny Talwar RSS

    Is It Possible filter in one expression with the value got it in other one?

    Leonardo Lopez

      Regards,

      I want to apply a filter in one expression with the value got it in other one.

       

      For example I have a expression like: fractile(AMOUNT,0.95)

       

      And in other expression I want to know how much registers there are greater than the value get previous.

       

      I have this: =Aggr(count({<AMOUNT={'>=$(=fractile(AMOUNT,0.95))'}>}ACCOUNT_NUMBER),SIC)

       

      The value that I am getting is greater than the total fracile of the chart, and not with the greater than the dimension.