Formula Tool

razzy

Hi all,

I want to use the formula tool to create a field from two existing fields, the calculation of the field will be like

let say the field is "C" , from existing fields " A" and "B"

C=A-B iff A is greater than B

else C=B-A ; B is greater than A

This is pretty easy in any programming language , i just too new to alteryx

How do i go about to get this formula;

thanks

Common Use Cases

Accepted answers

bharti_dalal

hi @razzy, Did you verify the data type of your fields? i hope they are not strings . I am attaching the solved workflow with two solutions. Screenshot (176).png

formula.yxzp

All comments

LordNeilLord

Hey @razzy

Try:

IF A>B THEN A-B
ELSEIF B>A THEN B-A
ELSE NULL()
ENDIF

You don't necessarily need the null but I usually put it in to capture any that don't apply to the rule

If statements must always follow IF THEN ELSE ENDIF

NEIL

david_fetters

If youre looking for IIF or a ternary operator, then Alteryx has it. See: https://help.alteryx.com/9.5/Reference/Functions.htm

Just create a formula tool and new field C with the following formula

IIF([A]>[B],[A]-[B],[B]-[A])

razzy

So the syntax worked well with no error, but i am not getting the output on the created field to get the desired result on each field, at the first run it came up as null right through on the column then i tried adjusting the data types of the field to match that of the calculated field i still got no output.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703