Focal Point
Formatting Issue - Minus symbol not preceeding the decimal value

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9491043032

May 31, 2007, 03:28 AM
Prasanna
Formatting 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


Dev:
Dev Studio 7.1.6,Report Caster 7.1.1,Servlet
Local:
Dev Studio 7.1.6,Report Caster 7.1.1,Apache 5.0.2,
Win XP


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 B
The '-' 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


Alan.
WF 7.705/8.007
June 01, 2007, 05:49 AM
Prasanna
It worked. Thanks.


Dev:
Dev Studio 7.1.6,Report Caster 7.1.1,Servlet
Local:
Dev Studio 7.1.6,Report Caster 7.1.1,Apache 5.0.2,
Win XP