0 Replies Latest reply: Jul 31, 2014 8:13 AM by Sailee Kumawat RSS

    Nested Aggregation and CountIf together

      Hello,

       

      I have written a set expression which calculates a measure for me.

       

      calculation:

      =(Sum(A)+(sum({<Account_Id={'4'}>}A)))/(sum({<Account_Id={'2'}>}A))        

       

      I need to check and count values of this measure that are greater than 0.95

       

      How can I achive this ?

       

      Thanks,

      Sailee