4 Replies Latest reply: Oct 26, 2017 9:01 AM by omar bensalem RSS

    Coverting a condtion to set analysis

    Aniruddhya Dutta

      Can some help me convert this as set analysis:


      I have some unique P_ids against which I am checking the below condition to  differntiate which are error and no error


      =if ( not IsNull(C_ID) and not match(P_STATUS,'success') and  match(P_NAME,'SPL') and aggr(count(if (match(P_STATUS,'errors'),1)),C_ID)=1,'error','no_error')


      I just want to get total number of 'error' or 'no_error'


      so I am expecting some thing like


      Count({$<condtion1,condition 2,condition 3>}  P_ids) -->total count for errors

      similar one for no_error.