Year |
Amount |
Amount New |
Start |
128680.57 |
128680.57 |
2023 - Q2 |
26413.41 |
26413.41 |
2023 - Q3 |
8026.91 |
8026.91 |
2023 - Q4 |
41497.96 |
41497.96 |
End of 2023 |
|
52743.00 |
2024 - Q1 |
8670.92 |
8670.92 |
2024 - Q2 |
5067.31 |
5067.31 |
2024 - Q3 |
2953.10 |
2953.10 |
End of 2024 |
|
36052.00 |
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
Is this doable ? Thank you so much.