Spreadsheet: 725086d1616521999-formula-needed-for-several-scenerios-summary-report-details
Sheet: Aug-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 | 9893.05 | 2015.04 | 11294.35 | 2364.01 | 1271.04 | 340.55 | 173.86 | 1001.09 | 1265.51 | 182.52 |  |  |  |  | 2376.92
Prior/Current | 2345 | Example Name | 0 | 0 | 0 |  | 2954.9 | 2002.86 | 65.53 | 62.55 | 124.65 | 77.4 | 34.86 | 33.56 |  |  |  |  | 1161.21
Prior/Current | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 87983.13 | 15395.92 | 639.64 | 158.82 |  |  |  |  | 7933.19
Prior/Current | 4567 | Example Name | 0 | 0 | 0 | 0 | 1619.58 | 868.01 | 325.14 | 221.6 | 305.99 | 30.8 | 482.43 | 180.97 |  |  |  |  | 817.18
Prior/Current | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1386.76 |  |  |  |  | 16435.99
Prior/Current | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 623.02 |  |  |  |  | 8093.64
Prior/Current | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16325 | 463.06 | 373.47 | 651.22 |  |  |  |  | 2213.59
Prior/Current | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 683.71 |  |  |  |  | 4216.44
Prior/Current | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82618.52 | 76.31 | 67.07 | 48.32 |  |  |  |  | 1224.82
Prior/Current | 9013 | Example Name | 0 | 0 | 0 | 0 |  | 262.17 | 2214.81 | 245.23 | 262.39 | 563.85 | 2676.81 | 560.99 |  |  |  |  | 2516.74
Used | 1234 | Example Name | 0 | 0 | -2376.92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 2345 | Example Name | 0 | 0 | 0 | 0 | -1161.21 | 0 | 0 | 0 | 0 | 0 | 0
Used | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7933.19 | 0 | 0
Used | 4567 | Example Name | 0 | 0 | 0 | 0 | 817.18 | 0 | 0 | 0 | 0 | 0 | 0
Used | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | -1386.76
Used | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | -623.02
Used | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2213.59 | 0 | 0
Used | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | -683.71
Used | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1224.82 | 0 | 0
Used | 9013 | Example Name | 0 | 0 | 0 | 0 | -262.17 | -2214.81 | -39.76 | 0 | 0 | 0 | 0
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