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
Solved! Go to Solution.
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
, ",","")