Sage X3 Africa and Middle East

Hi all I am trying to create a summary for all overtime hours paid per department in EM HR - I have created the following: 1. SQL Query SELECT SRV_0 ,ISNULL(OT,0) ,ISNULL(OTWKD,0) ,ISNULL(PH,0) ,'' ,'' ,'' ,'' FROM ZTCHCECK GROUP BY SRV_0…