if then else to create new column

[hash9]

My input data is

Position	Length
23	1
24	2

I want to create another column which should be

Position	Length	Column
23	1
24	2	25

if the length is "2", then it has to take this column "Position" and add 1. If it is 1, then leave it blank

I tried using if the clause, but i'm getting an error(Type mismatch in operator "+")

IF [length] = "2" THEN [position] + "1"
ELSE Null()
ENDIF

Can someone pls help me fix this?

Thanks!

[MarqueeCrew · Accepted solution]

Did you try...

IF [length] = 2 THEN [position] + 1
ELSE Null()
ENDIF

[WillTravelForData · Accepted solution]

I used the formula

IF [Length]=2 THEN [Position]+1 ELSE Null() ENDIF

in the attached workflow to populate the new column.

[hash9]

I tried and it worked. Thanks a lot