Tag multi fields negative values

Hi,

I try to find within my dataset ( multiple fields) all negative values and tag them as [Field1] + "-E", basically using a conditional if where a value is still positive to tag it as [Field1] + "-E".

I does not work with what I am trying in multi field tool

IF [_CurrentField_]<0

THEN [_CurrentField_] && "-A"
ELSE [_CurrentField_] && "-E"
ENDIF

* incoming data is fixed decimal type

Many thanks!

Screenshot 2021-12-27 123846.jpg

Workflow

Tips and Tricks

Transformation

Data Investigation

Accepted answers

binu_acs

@Tmanuela you need to update your Multi-Formula like below

Spoiler

MultiField.yxmd

Qiu

@Tmanuela
The only difference is that I did not check the Copy To New Column option?

Any ways, this is for the 2nd request.

New Workflow6A.yxmd

All comments

Qiu

@Tmanuela
I assume the issue is that your original field is of Double, and by your tagging, it will change to string, so you need to change the data type of your field., and also use the t