Error: Multi Field Formaula - Parse Error at char (n): Malformed Function Call

[HassimDiallo]

I am trying to solve for the below issue. I have trailing signage that are getting dropped at the end of my workflow and losing all my credit (-) balances and becoming positive. For example 2000- should be -2000.

Amount

2000-

15

45-

Using the below Multi Field formula and getting Parse Error at char (n): Malformed Function Call error. It looks like a parenthesis might be missing somewhere but i am able to see what's wrong with it.

ToNumber (IF Right(Trim([_CurrentField_]),1) = "-" THEN ToNumber ( Left(Trim([_CurrentField_]), Length(Trim([_CurrentField_]))*-1
ELSE [_CurrentField_]
ENDIF)

Please help with troubleshooting.

Thank you

[Bren_Spill2 · Accepted solution]

@HassimDiallo - try this. Left the New_ columns in there so you can see the change:

[HassimDiallo]

@Bren_Spill2 Thank you for the suggestion. It worked! I appreciate your help.

Regards,

Hassim

[Bren_Spill2]

No problem @HassimDiallo !