FROM prod.prtime prt
WHERE( prt.tr_date >= add_months(trunc(sysdate, 'mm'),-12)
AND prt.tr_date < trunc(sysdate) )
and prt.pay_sum_grp in ('REG', 'REGH','OT','ED','OREN')
-- and prt.employee = 19330
and emp.company = prt.company (+)
and emp.employee = prt.employee (+)
group by prt.employee ) HOURS_WORKED
For the most part, all the values come across. The issue I'm having is if the value is 0, a blank is being displayed instead of the 0.
Is there anything I can do to ensure that the 0's appear.
I've attached a file with the results I'm getting. Blanks.docx