Forum Discussion
Create new column based on other columns
Hello All,
I have data as below and neww to create a new column as below.
If the activity is OT need to add the year end and forecast if it is SU need the value from Forecast column.Thanks for help
| Activity | Year End | Forecast | New coulmn |
| OT | 12 | 1 | 13 |
| OT | 12 | 1 | 13 |
| OT | 0 | 4 | 4 |
| OT | 0 | 4 | 4 |
| OT | 0 | 5 | 5 |
| OT | 0 | 6 | 6 |
| OT | 0 | 7 | 7 |
| SU | 8 | 9 | 9 |
| SU | 10 | 11 | 11 |
| SU | 12 | 13 | 13 |