Create new column based on other columns

[Anonymous]

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

[Anonymous · Accepted solution]

@Anonymous 

Column = IF(Test[Activity]="SU",Test[Forecast],Test[Year End]+Test[Forecast])

[Anonymous]

Thanks