Cross subject areas analysis reports

Summary

adding salary to a 'worker assignment' analysis report

Content

Hello.

I have created an analysis report that takes all fields on Fusion I find important and shows for each employee on which field the employee has data anomaly (for example missing gender, missing grade and so on) based on a small manipulation i did for each field (switch case if the value is null).
the report uses the subject area: "workforce management - worker assignment real time". all fields derives from there.
the report worked well, but when i added the field "new salary" into the report from another subject area called: "Compensation - salary details real time", the report doesn't show any value on the field, even for employee who has a salary record.