REMOVE PARENTHESIS AND REPLACED IT INTO NEGATIVE SIGN

dunkindonut7777

Hi I have a problem removing the parenthesis in an amount field, I want to replaced it into negative sign.

For example:

Functional Amount

(500)

then I want to have it as "-500'

Can you help me with this one please?

Accepted answers

All comments

atcodedog05

Hi @dunkindonut7777

Here is a workflow for the task.

Output:

Formula:

"-"+Trim([Functional Amount],"()")

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

no mod.yxmd

dunkindonut7777

Hi thank you for this one. I just got a problem with the positive numbers, they were replaced as negative also, how to convert it without touching the positive numbers?

atcodedog05

Hi @dunkindonut7777

I have added a condition to handle this.

IIF(Contains([Functional Amount], "("), "-"+Trim([Functional Amount],"()"), [Functional Amount])

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Qiu

@dunkindonut7777

How about a simple Find and Replace?

1123-clodelegonzales.yxmd

marcusblackhill

Hey @dunkindonut7777 !

Another easy solution for you is to use the formula tool with 2 simple replaces like in the print.

Hope that help you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703