Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Multiple Expressions in Multi-Field Formula

jmarleigh
7 - Meteor

Hi,


I was just wondering if it was possible to have multiple expressions in a multi-field formula.

 

Currently I have two multi-field formulas chained together, the first to move negatives from the end of a number to the beginning.

 

IF Right([_CurrentField_],1) = "-"
THEN "-" + LEFT([_CurrentField_],Length([_CurrentField_])-1)
ELSE [_CurrentField_]
ENDIF

 

and the second to remove commas from with a number.

 

replace([_CurrentField_],",","")

 

I would like to put these into a single expression.

 

Thanks,

Justin

JohnJPS
15 - Aurora

HI @jmarleigh

You can embed one expression into the other, for instance:

REPLACE(
IF Right([_CurrentField_],1) = "-"
THEN "-" + LEFT([_CurrentField_],Length([_CurrentField_])-1)
ELSE [_CurrentField_]
ENDIF
, ",","")

 

 

Labels