Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - I have table as below.
ID | End Date | 2021 | 2022 | 2023 | 2024 | 2025 |
1 | 12/31/2021 | 100 | ||||
2 | 12/31/2023 | 100 | 200 |
Here ID '1' has the End date of 12/31/2021 - so, we want to assume it has the end date of 2025 and add $100 to 2022, 2023, 2024,2025
and ID '2' has the end date of 2023 - so want to assume it has the end date of 2025 and add $150 (pick the last available amount) to 2024 and 2025.
The output will be as below.
ID | End Date | 2021 | 2022 | 2023 | 2024 | 2025 |
1 | 12/31/2021 | 100 | 100 | 100 | 100 | 100 |
2 | 12/31/2023 | 100 | 200 | 150 | 150 | 150 |
Is this doable ?
@stevejoyce Beautiful. Thank you much 🙏