11 Replies Latest reply: Dec 19, 2016 5:01 AM by sagar kharpude RSS

    How to use an IF condition and count the records

    Padmanabhan Ashok

      Dears,

       

      I am having an requirement to apply an IF condition on a field and once its True I need to do a count on another field.

       

      =if(T_TOR_CODE = 'CC', count(distinct T_STATUS = 'APPROVED'))

       

      in the statement  I want if the T_TOR_CODE = 'CC'  then I need to count on a field where T_STATUS = 'APPROVED'

       

      Ashok