function CF_PRESENTFormula return Number is
v_emps number;
begin
select count(1)
into v_emps
from hrm_employees e,hrm_inout i
where e.employeecode=I.employeecode
and i.intime=:TO_CHAR_MIN_I_INTIME_HH_MI_AM
and :TO_CHAR_MIN_I_INTIME_HH_MI_AM is not null;
return v_emps;
end;

i want a farmula column that return records that dont have intime!
like in screan below and i want to show "------" when intime is null i did it in property "value if null"
these are in department group!
i want to show them as present!

no i just want to count how manay employee has intime!
i don't want to count those have null intime,
and also i want to disply value"-----" if there in time is null,
i did it in property "value if null"
in image it is showing 3 present they have intime
i use a summery column to count intime, if i use value if null then it shows all seven present!