Total compensation statement is adding the values

Summary:

Total compensation statement is adding the values

Content (required):

Hi Experts,

We have configured total compensation statement item which displays the basic salary of employee. The source of the item is coming from

element entry. But if we update the value in element entry the total compensation statement adds the previous value and the present value.

For example: Element name : Basic India.

Employee has a value of 24,000 with Effective start date of 1 may 2022 and we update this element entry value to 28,000 with effective start date as 1 st Nov 2022. Now total compensation statement adds 24, 000 and 28,000 and gives final values as 52,000 in the statment. How to restrict this?. We need only the latest value in the total compensation statement.