Return Accruals
Hello Everyone,
I would like to write a plsql which return complete table and same insert into a separate table, the available data which i have is as bellow:
I am attaching my working sheet, in first sheet mention my available data and in second sheet green highlighted fields my desire results.
| Income | Disbursement Date | 18-Dec-17 |
|---|---|---|
| 1,266,666.67 | Rental Dates | 18-Mar-18 |
| 1,232,432.43 | 18-Jun-18 | |
| 1,198,198.20 | 18-Sep-18 | |
| 1,163,963.96 | 18-Dec-18 | |
| 1,129,729.73 | 18-Mar-19 | |
| 1,095,495.50 | 18-Jun-19 | |
| 1,061,261.26 | 18-Sep-19 | |
| 1,027,027.03 | 18-Dec-19 | |
| 992,792.79 | 18-Mar-20 | |
| 958,558.56 | 18-Jun-20 | |
| 924,324.32 | 18-Sep-20 | |
| 890,090.09 | 18-Dec-20 | |
| 855,855.86 | 18-Mar-21 | |
| 821,621.62 | 18-Jun-21 | |
| 787,387.39 | 18-Sep-21 | |
| 753,153.15 | 18-Dec-21 | |
| 718,918.92 | 18-Mar-22 | |
| 684,684.68 | 18-Jun-22 | |
| 650,450.45 | 18-Sep-22 | |
| 616,216.22 | 18-Dec-22 | |
| 581,981.98 | 18-Mar-23 | |
| 547,747.75 | 18-Jun-23 | |
| 513,513.51 | 18-Sep-23 | |
| 479,279.28 | 18-Dec-23 | |
| 445,045.05 | 18-Mar-24 | |
| 410,810.81 | 18-Jun-24 | |
| 376,576.58 | 18-Sep-24 | |
| 342,342.34 | 18-Dec-24 | |
| 308,108.11 | 18-Mar-25 | |
| 273,873.87 | 18-Jun-25 | |
| 239,639.64 | 18-Sep-25 | |
| 205,405.41 | 18-Dec-25 | |
| 171,171.17 | 18-Mar-26 | |
| 136,936.94 | 18-Jun-26 | |
| 102,702.70 | 18-Sep-26 | |
| 68,468.47 | 18-Dec-26 | |
| 34,234.23 | 18-Mar-27 |
The result which i want to extract in table from my saved data is as bellow:
Tagged:
0