Query to get the rollover balance of Annual Absence Plan on January-1-2024
Hi Guys, i have i have scenario, Plan A and Plan B. Plan A is Base plan and Plan B is target Plan where rollover is being transferred.
for example Plan A has 20 balance at the year end 31-december 2023 and that was roll overed to Plan B on 01-january 2024. But along with rollover Plan B has carryover of balance 3 and it became 23. Now i want a query to extract only the rollover balance of the Plan B on the date January -01- 2024.
Please help me with the query.
Content (please ensure you ma
Content (please ensure you mask any confidential information):