Multiple Expressions in Multi-Field Formula

[jmarleigh]

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 · Accepted 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
, ",","")