Incorrect values are appearing in OTBI report for leave duration

Summary:

We have created OTBI report where we are fetching absence details based on year and month (monthly absence report). If employee has taken leave for single month (eg: start date: 08Sept25 end date: 15Sept25) leave duration is coming as expected for month of august. But if leaves are in between two months (eg: start date: 29Aug25 end date : 05Sept25) total count is getting calculated in month of August, ideally count should be calculated based on month.

Subject area used : Workforce Management - Absence real time

Columns: Person number, name, absence start and end date, month, leave duration from Assignment absence.