Adding a character in front of an IF formula result

[bacon1983]

Hi I would like to add a negative sign "-" to go in front of the very 1st character of an IF result [notional]

Currently when the IF is TRUE this returns 10,000,000

I would like it to return -10,000,000

Field is currently set a s VW_String

IF Contains([Instrument], "Straddle") THEN
[Notional] ELSE
[pay: notional]
ENDIF

[christine_assaad · Accepted solution]

Hi @bacon1983 

Would you please try to see if the below would work for you?