Dear Alteryx Community,
Is there a way to calculate values using values in a different row? In this case, the forecasted Divisional Allocations should equal Operating & Maint Expense times -1. It is different than turning the positive Op Exp into negative value within the same row. Any help would be greatly appreciated.
| Acct Category | 2021 Budget | 2022 Forecast | 2023 Forecast | 2024 Forecast | 2025 Forecast | 2026 Forecast | 2027 Forecast | 2028 Forecast | 2029 Forecast | 2030 Forecast |
| Operating Revenues | | | | | | | | | | |
| Operating & Maintenance Expense | 1,328,093 | 1,372,476 | 1,418,394 | 1,460,946 | 1,504,775 | 1,549,918 | 1,596,415 | 1,644,308 | 1,693,637 | 1,744,446 |
| Income from Operations | (1,328,093) | (1,372,476) | (1,418,394) | (1,460,946) | (1,504,775) | (1,549,918) | (1,596,415) | (1,644,308) | (1,693,637) | (1,744,446) |
| Corporate Allocations | - | - | - | - | - | - | - | - | - | - |
| Divisional Allocations | (1,328,093) | - | - | - | - | - | - | - | - | - |
| Total Allocations | (1,328,093) | - | - | - | - | - | - | - | - | - |
| Net Operating Income | - | 1,372,476 | 1,418,394 | 1,460,946 | 1,504,775 | 1,549,918 | 1,596,415 | 1,644,308 | 1,693,637 | 1,744,446 |
| Depreciation Expense | - | - | - | - | - | - | - | - | - | - |
| Net Income | - | 1,372,476 | 1,418,394 | 1,460,946 | 1,504,775 | 1,549,918 | 1,596,415 | 1,644,308 | 1,693,637 | 1,744,446 |
