Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
(count({< [TYPE],[ REASON],[GRP] = >} (if([JOB ]<> 'DIRECT', EMPNUM))))/2
I am trying to understand what does {< [TYPE],[ REASON],[GRP] = >} part mean in above expression. Is it used for counting distinct of all 3 combination? no value after = means?
Those means that you are just ignoring any direct selection made in those fields for this expression. I would also remove the id statement and make this the expression:
Count({<[TYPE],[ REASON],[GRP], JOB -= {'DIRECT'}>} EMPNUM)/2
Note the red negative sign in front of the equal sign after JOB field....