Negative value currency formatting

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!

Reporting

Output

Accepted answers

Maskell_Rascal

Hey @dnomasur

Here is how you can do it.

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

Hope this helps.

Cheers!

Phil

All comments

Jonathan-Sherman

Hi @dnomasur,

You could replace your $- string with -$?

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

Kind regards,

Jonathan

Maskell_Rascal

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703