Forum Discussion

TroyTroy1's avatar
TroyTroy1
Qrew Trainee
8 years ago

Change entered values to positive or negative values

I have been requested to create a field that changes negative numbers to positive numbers and positives to negative numbers after being entered in the field. I looked at using the ABS but only works w...
Formulas and functions
HillaryWhitney's avatar
HillaryWhitney
Qrew Cadet
5 years ago
Where would I place this script to change my field to a negative? Do I need to change my field type from currency to formula - numeric?

------------------------------
Hillary Whitney
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
One way is to create a new formula field  with the formula

-[field which is positive]


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------