How to use an IF condition and count the records

[pashok75]

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

[vinieme12]

use  -(minus)=(equal)

=count({< T_TOR_CODE = {'DP'}, T_STATUS -= {'APPROVED'}>} T_STATUS)

[sagarkharpude]

=count({< T_TOR_CODE = {'DP'}, T_STATUS ={'*'}- {'APPROVED'}>} T_STATUS)