Monarch Function Question
New Altair Community Member
Updated by Melissa_21551
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
| TOTAL | Total Reversed | ||
|---|---|---|---|
| TOTAL | 17,819,123.87- | Total Reversed | 17,819,123.87 |
| TOTAL | 32,220.36- | Total Reversed | 32,220.36 |
| TOTAL | 18,465,712.39 | Total Reversed | 18,465,712.39- |
| TOTAL | 7,597.36 | Total Reversed | 7,597.36- |
Thank you!
Melissa
Sort by:
1 - 2 of
21
Altair EmployeeUpdated by Altair Forum User
The easiest way to achieve this is to create a formula field and multiply the value by -1.
Thank you!
The easiest way to achieve this is to create a formula field and multiply the value by -1.