Make number negative based on other field

Like (0) Share

Report

Posted on 25 May 2022 01:10:50 by zerodarkbirdy

Hello,

Is there a way to set a field negative based on another field without making the number field a text field?

Here's what I'm trying to do:

If the Movement fields shows Remove, I would like the number in the Quantity section to automatically be negative. If the Movement field shows Add, then leave the number as is. When the data field is number, it does not allow me to input a negative.

Any help would be greatly appreciated.

Thank you!

Remove

Add

Categories:

Mobile App

General Questions

Using Apps Using Formulas

All responses (2)

Answers (1)

zerodarkbirdy 5 on 08 Jun 2022 at 22:24:55

Like (0)

Report

Re: Make number negative based on other field

Looks like this worked! Thank you! I had to rearrange the fields so that the quantity is inputted first and not the movement, but other than that the change worked great. Thank you for you help.
Verified answer

v-liwei-msft on 31 May 2022 at 09:50:18

Like (1)

Report

Re: Make number negative based on other field

Hi @zerodarkbirdy ,

1. you can use the switch function to determine: when "movement" is "add" ,the "amount" is 10; When "movement" is "remove", the "amount" is -10.
2. When "movement" is "remove", you can convert the amount to a string and then add "-" and then use the value function to convert the string to a number.
I have made a test for your reference:

Switch(
DataCardValue2.Selected.Value,
"add",
ThisItem.quantity,
"remove",
Value("-" & Text(ThisItem.quantity))
)

Best Regards,
Levi