Negative value currency formatting

[dnomasur]

Hi all,

Long time reader, first time poster.  This seems like a pretty basic question, but so far I haven't found any other discussion threads covering it.

I have a column of numerical values (both positive and negative) that I converted to string so that I could then also format them with a "$" sign.  This works fine for positive values (for example $5.3), but with negative values I'm instead getting "$-5.3".

Is there a way to format the negative values differently so that the negative sign appears in front of the '$' sign -- for example "-$5.3"?

Any help would be greatly appreciated -- thanks!

[Jonathan-Sherman]

Hi @dnomasur,

You could replace your $- string with -$?

Replace([String], '$-', '-$')

Kind regards,

Jonathan

[Maskell_Rascal · Accepted solution]

Hey @dnomasur 

Here is how you can do it. 

IF StartsWith([Data], '-') THEN Replace([Data], '-', '-$') ELSE '$'+[Data] ENDIF

Hope this helps.

Cheers!

Phil

[dnomasur]

Thanks guys -- I'm sure one of these solutions will work and will try them shortly.  And greatly appreciate the rapid responses!