In Crystal reports there is a formatting option to reverse the sign for display? Basically although the number is negative the user would like it displayed as a positive but only at certain group levels. Is there a way to display the absolute value of a number only? Or is there a formatting option I am missing where for display purposes you can remove the negative sign.
Julia
2 answers
Hi Julia,
While there is no formatting option to reverse the sign, a calculated field can be created that uses the ABS() function to return the absolute value, as documented in the Tableau Desktop Product Help Library:
Cheers!
- Jordan
