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.
Solved! Go to Solution.
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
Hi @Deano_280
Have done the modification in the formula shared,
1. Added tonumber() this helps to convert string to number checking age > comments
2. After THEN removed the column name, as it is given at the top
Many thanks
Shanker V
That's done it thank you very much!