The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
I have data that gives me several totals. I need to change the signs of value for each number. So if the number is positive I need it to be negative and if the number is negative I need it to be positive. Is there a function available that I can use to achieve this. Or any other work around? Below is an example of what I am looking for.
What I Have: What I need
Thank you!
Melissa
The easiest way to achieve this is to create a formula field and multiply the value by -1.