SteveL13
asked on
How display negative number as a positive number
I have a report that will always display a number as a negative value (example: -125,235) How can I force the report to show these numbers as a positive number. (125,235)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Absolute Value Function ...
ABS()
mx
ABS()
mx
ASKER
Sorry, the number I used is just an example of the numeric value. The actual field control souce is [Net]. So then what would the syntax be?
the OP doesn't just want the positive #, they want to use an accounting format, which wraps the negative number in parenthesis.
so maybe:
=IIF(sgn(MyValue) = -1, "(" & abs(MyValue) & ")", MyValue)
so maybe:
=IIF(sgn(MyValue) = -1, "(" & abs(MyValue) & ")", MyValue)
=ABS([Net])
mx
mx
Steve ... I posted the exact same answer ... First ...using the ABS function
mx
mx
mx