Help - I have a negative value on which I want the negative symbol to be in front

[Naga]

Hi Team,

Please help on a formula, if there is something straight. I need the negative input (-164.15) to be displayed as (164.15-).

Thanks

Naga

[Aaron_Harter · Accepted solution]

@Naga, 

You'll want to create a new string field and leverage a conditional formula:

 

[Jonathan-Sherman · Accepted solution]

Hi @Naga,

There are many ways in which this could be done, just to add an alternative to @Aaron_Harter you could use:

REGEX_Replace(ToString([Value]), '^(-)?(.*)', '$2$1')

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan