Cumulative Salary Report
Summary:
Financial report of cumulative salaries per reporting period
Content (please ensure you mask any confidential information):
Hi experts
I have a request to provide 2 reports: The first is a report of salaries for each reporting month - which accumulates (so for Jan there is one record, for Feb there is 2 etc). Then the second report is a cumulative summary of the records (so Jan will be 4000 as an example, and Feb will be 8000 etc).
The challenge I have is that the Workforce Trend SA provides the year and month (so 2025, Jan, 2025, Feb etc), but when you add the Annualized salary in - the salary change date in the Compensation - Salary Real Time SA, dominates and the salary data only returns with the salary change date - not the Workforce Trend Date.