Spreadsheet: 725085d1616521892-formula-needed-for-several-scenerios-summary-report-details
Sheet: Sep-20

 | Month: | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | New Credits
 | SC | SC Name | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | Total |  |  | Pre-Invoice Amounts | ECR Applied | Invoice Amts
Prior/Current | 1234 | Example Name | 0 | 0 | 7516.13 | 2015.04 | 11294.35 | 2364.01 | 1271.04 | 340.55 | 173.86 | 1001.09 | 1265.51 | 182.52 | 465.63 |  |  |  | 2360.23
Prior/Current | 2345 | Example Name | 0 | 0 | 0 |  | 1793.69 | 2002.86 | 65.53 | 62.55 | 124.65 | 77.4 | 34.86 | 33.56 | 13.66 |  |  |  | 1179.56
Prior/Current | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 72019.71 | 15395.92 | 639.64 | 158.82 | 164.17 |  |  |  | 7768.89
Prior/Current | 4567 | Example Name | 0 | 0 | 0 | 0 | 802.4 | 868.01 | 325.14 | 221.6 | 305.99 | 30.8 | 482.43 | 180.97 | 62.47 |  |  |  | 821.74
Prior/Current | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 1022.51 |  |  |  | 16474.73
Prior/Current | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 314.72 |  |  |  | 8208.96
Prior/Current | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14111.41 | 463.06 | 373.47 | 651.22 | 190.09 |  |  |  | 2178.7
Prior/Current | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 370.16 |  |  |  | 4251.79
Prior/Current | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 81393.7 | 76.31 | 67.07 | 48.32 | 29.33 |  |  |  | 1418.89
Prior/Current | 9013 | Example Name | 0 | 0 | 0 | 0 |  |  |  | 205.47 | 262.39 | 563.85 | 2676.81 | 560.99 | 354.48 |  |  |  | 2590.42
Used | 1234 | Example Name | 0 | 0 | -2360.23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 2345 | Example Name | 0 | 0 | 0 | 0 | -1179.56 | 0 | 0 | 0 | 0 | 0 | 0
Used | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -7768.89 | 0 | 0
Used | 4567 | Example Name | 0 | 0 | 0 | 0 | -802.4 | -19.34 | 0 | 0 | 0 | 0 | 0
Used | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | -1022.51
Used | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | -314.72
Used | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2178.7 | 0 | 0
Used | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | -370.16
Used | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1418.89 | 0 | 0
Used | 9013 | Example Name | 0 | 0 | 0 | 0 |  |  |  | -205.47 | -262.39 | -563.85 | -1558.71
Remaining/Carried Forward | 1234 | Example Name | 0 | 0
Remaining/Carried Forward | 2345 | Example Name | 0 | 0
Remaining/Carried Forward | 3456 | Example Name | 0 | 0
Remaining/Carried Forward | 4567 | Example Name | 0 | 0
Remaining/Carried Forward | 5678 | Example Name | 0 | 0
Remaining/Carried Forward | 6789 | Example Name | 0 | 0
Remaining/Carried Forward | 7890 | Example Name | 0 | 0
Remaining/Carried Forward | 8901 | Example Name | 0 | 0
Remaining/Carried Forward | 9012 | Example Name | 0 | 0
Remaining/Carried Forward | 9013 | Example Name | 0 | 0