topic Re: Using formula tool to produce text, currently only showing 0 in output column. in Alteryx Designer Desktop Discussions

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

Deano_280 — Sat, 06 Apr 2024 10:17:44 GMT

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.

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

ShankerV — Sat, 06 Apr 2024 10:25:18 GMT

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

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

ShankerV — Sat, 06 Apr 2024 10:29:44 GMT

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

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

Deano_280 — Sat, 06 Apr 2024 10:38:40 GMT

That's done it thank you very much!