Using formula tool to produce text, currently only showing 0 in output column.

Hi guys,

I am trying to produce a text output which is based off comparing two numeric columns. Formula I'm using below however the output only shows 0 instead of the text shown below.

Age, Comments and Commentary columns all set to V_String.

IF
[AGE]<[Comments] then [Commentary] = "within policy"
elseif [AGE]>=[Comments] then [Commentary] = "outside of policy"
ELSE
Null()
ENDIF

Thanks in advance.

Capture.PNG

Datasets

Accepted answers

ShankerV

Hi @Deano_280

Please use the below.

IF ToNumber([AGE])<ToNumber([Comments])
THEN "within policy"
ELSEIF ToNumber([AGE])>=ToNumber([Comments])
THEN "outside of policy"
ELSE Null()
ENDIF

Many thanks

Shanker V

All comments

ShankerV

Hi @Deano_280

Please use the below.

IF ToNumber([AGE])<ToNumber([Comments])
THEN "within policy"
ELSEIF ToNumber([AGE])>=ToNumber([Comments])
THEN "outside of policy"
ELSE Null()
ENDIF