Hi - I have data as above.I need to calculate 'Amount' column for 'End of 2023' and 'End of 2024' based on that year qtr's data. Amount New is the column I manually calculated to show what the expected numbers are.
Ex: start expense is 128,680 and total expense (Q2+Q3+Q4) for 2023 is (75,938), so by end of 2023, we have 52,743 (128,680 - 75,938)
Now for 2024 (Q1+Q2+Q3) is 16,691.End of 2024 should be (End of 2023 - all 2024 expense) 52,743 - 16,691 = 36,052
