If you say your data import is complete and no error in formula, however, your final value is not correct, it could imply;
value in source data missing (no error during data import doesn't mean your source data is correct! there could be missing values or wrong values too)
mapping is incomplete (employee doesn't have either Department or Role assigned, again due to missing info in source file)
Keep in mind, you are referencing data from source module based on lookup function in mapping table (reading employee to Dept / Role relationship). Please check your source (SYS08 and EMP03) and reload if necessary.