Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use -(minus)=(equal)
=count({< T_TOR_CODE = {'DP'}, T_STATUS -= {'APPROVED'}>} T_STATUS)
=count({< T_TOR_CODE = {'DP'}, T_STATUS ={'*'}- {'APPROVED'}>} T_STATUS)