May 31, 2007, 03:28 AM
PrasannaFormatting Issue - Minus symbol not preceeding the decimal value
I am trying to format a column with D12.2-!D (giving 2 decimal space, with dollar sign and setting minus symbol if there is a negative value).
In output i am getting the number s
$20.45-
i need the output as
-$20.45
Any idea why this formatting shows the output differently?
Regards
May 31, 2007, 03:36 AM
<JG>You should just use D12.2!D NOT D12.2-!D
May 31, 2007, 03:43 AM
Alan BThe '-' in the format for a field displays a -ve sign to the right of the number, as stated in the manual. This changes the normal position which is a leading -ve sign.
Just use D12.2!D to get a leading -ve sign