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!
Solved! Go to Solution.
Did you try...
IF [length] = 2 THEN [position] + 1
ELSE Null()
ENDIF
I tried and it worked. Thanks a lot