Forum Discussion
Solved
How do I create incremental values in a column (Multiply by 2) based on a column condition (Year)
Hello Everyone, I have a tricky situaltion where I need to create incremental values in a column (Multiply 0.03 by 2 starting from year 2023) based on a column condition (Year) and increments through...
| Year | Projects | Cost | Growth Rate | Inflation Rate |
| 2023 | B02 Admin/Visitor Bldg | $348,327 | 0.03 | 0.06 |
| 2024 | B02 Admin/Visitor Bldg | $3,323,044 | 0.06 | 0.12 |
| 2025 | B03 Warehouse | $628,142 | 0.09 | 0.18 |
| 2026 | B03 Warehouse | $2,996,237 | 0.12 | 0.24 |
| 2027 | B03 Warehouse | $3,176,011 | 0.15 | 0.3 |
| 2027 | B04 Shop 2 | $949,337 | 0.15 | 0.36 |
| 2028 | B04 Shop 2 | $4,528,339 | 0.18 | 0.36 |
| 2029 | B04 Shop 2 | $4,800,039 | 0.21 | 0.42 |
| 2030 | B05 Lumber Blast Shed & Paint Shop | $696,193 | 0.24 | 0.48 |
| 2031 | B05 Lumber Blast Shed & Paint Shop | $320,840 | 0.27 | 0.54 |
| 2032 | B05 Lumber Blast Shed & Paint Shop | $3,520,090 | 0.3 | 0.6 |