Hi All,
Hope you are all well.
I am getting incorrect values when calculating running balance which I need help with. Can you pls assist.
Running Balance Column calculation condition =
1. IF Debit/Credit Date < Todays Date, (Credit Limit - Amt) when Entry Type = ( "DEBIT and CREDIT)
2. IF Debit/Credit Date >= Todays Date, (Credit Limit - Amt) when Entry Type = "PENDING.
| ID | Name | Credit Limit | Credit Limit Start Date | ENTRY TYPE | Debit/Credit Date | Amt | Running Balance |
| 1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 7th Nov 2022 | -1000 | 9000 |
| 1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 15th Nov 2022 | -100 | 8900 |
| 1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 7th Dec 2022 | -500 | 8400 |
| 1 | Joe Bloggs | 10000 | 5th Nov 2022 | CREDIT | 15th Dec 2022 | 500 | 8900 |
| 1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 7th Jan 2023 | -600 | 8300 |
| 1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 8th Jan 2023 | -200 | 8100 |
| 1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 10th Jan 2023 | -300 | 7800 |
| 1 | Joe Bloggs | 10000 | 5th Nov 2022 | PENDING | 15th Jan 2023 | 150 | 7800 |
| 1 | Joe Bloggs | 10000 | 5th Nov 2022 | PENDING | 20th Jan 2023 | 200 | 7800 |
| 1 | Joe Bloggs | 10000 | 5th Nov 2022 | PENDING | 23rd Jan 2023 | 0 | 7800 |
| 1 | Joe Bloggs | 20000 | 10th April 2023 | CREDIT | 15th April 2023 | 0 | 20000 |
| 1 | Joe Bloggs | 20000 | 10th April 2023 | DEBIT | 20th April 2023 | -200 | 19800 |
| 1 | Joe Bloggs | 20000 | 10th April 2023 | DEBIT | 20th April 2023 | -300 | 19500 |
| 1 | Joe Bloggs | 20000 | 10th April 2023 | PENDING | 30th April 2023 | 1000 | 20500 |
| 1 | Joe Bloggs | 20000 | 10th April 2023 | PENDING | 30th June 2023 | 1000 | 21500 |
| 1 | Joe Bloggs | 20000 | 10th April 2023 | PENDING | 30th July 2023 | 100 | 21600 |
| 1 | Joe Bloggs | 20000 | 10th April 2023 | PENDING | th Aug 2023 | 500 | 22100 |
Thanks,
Sekhar
