NO_OF_PRINCIPALS = 7 - cmiss(NRIC1,NRIC2,NRIC3,NRIC4,NRIC5,NRIC6,NRIC7); This is exactly what I wanted, and I can see why it will work, but unfortunately my company is still using 9.1.3. I prefer one-line functions. Meanwhile I am using the verbose IF THEN Clause: IF NRIC1='' THEN NO_OF_PRINCIPALS = 0; ELSE IF NRIC2='' THEN NO_OF_PRINCIPALS = 1; ELSE IF NRIC3='' THEN NO_OF_PRINCIPALS = 2; ELSE IF NRIC4='' THEN NO_OF_PRINCIPALS = 3; ELSE IF NRIC5='' THEN NO_OF_PRINCIPALS = 4; ELSE IF NRIC6='' THEN NO_OF_PRINCIPALS = 5; ELSE IF NRIC7='' THEN NO_OF_PRINCIPALS = 6; ELSE NO_OF_PRINCIPALS = 7;
... View more