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



      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'