Hi,
My formula is not working for contracts greater than 12 months and hence it is showing the total billed amount (sum G2:AB2) > D2 as shown for Customer B in the attached file.
Ideally, for Customer B- Feb 2023 should have $67,500 and everything else should be Zero. However, my current formula is calculating $67,500 in Feb 2024 also.
Please help me fix the error
Bookmarks