Element Entry Changes Report

Summary

Copying an existing BI Publisher version

Content

Hi,

I'm trying to replicate a BI Publisher report that HR runs each month and submits to payroll. I'd like the report to show all changes to element entries made between a FROM DATE - TO DATE.

The element change must be on the same line - in OTBI they appear on separate lines which doesn't work. I also require 2 new columns (highlighted in Green), 1. a calculated column which I think I can do but also a % change column which I'm less sure off. I have attached a dummy record showing the Responsibility Allowance changing to NULL on the 1st Jul - this must be on one line - is this possible?