As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025.
If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025 and the conditions for Jan 2025 are met, then $20 is applied against the $100 from Jan 2024. The balance would be reduced accordingly (e.g., to $80). Similarly, if the conditions are not met in Mar 2025, then the $20 available in Mar 2025 would instead be used to pay down the $80 remaining from Feb 2024.
This payment schedule continues until either all amounts to be paid are fully settled or all available funds are used up.
Because the logic involves checking two time dimensions against each other, with accumulation required, a circular reference may occur if one of the time dimensions is converted into a “fake time” list.
Any possible solutions? Much appreciate it!
