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 |
Solved! Go to Solution.
@PETER_SUPPIPAT
Lets just turn the rows into columns.
Hi Qiu, That works great. Thank you so much for your kind assistance with this. Is there a way to reorder the row in a specific sequence? The output file should have the below order.
@PETER_SUPPIPAT
Added some small processing. 😁
Qiu, This is great. Thank you so much for taking your time to put together the workflows and sharing your knowledge with me. I found this very useful. Your help is greatly appreciated.
@PETER_SUPPIPAT
Glad to hep and thank you for the warm word 😁