In Query I have always had good luck with "Numeric editing choices".  I turn
on the currency symbol, change it to % on the right or leave $ on the left.
I let $ float at the front and turn on "Single leading zero".

Doug Ritsema
Holland American Wafer Co.
 

-----Original Message-----
From: Bonnie_Lokenvitz@xxxxxxxxxxxxxx
[mailto:Bonnie_Lokenvitz@xxxxxxxxxxxxxx]
Sent: Wednesday, April 07, 2004 6:39 AM
To: MAPICS ERP System Discussion
Subject: Re: Query/400: Adding % or $ signs to Report Followup




Try this - from the DDS manual:

If you use the floating-currency symbol, it is not counted as a digit
position.

For example, if you specify the floating-currency
symbol for a field length of 7 and 2 decimal positions, the edit word is:

         EDTWRD('____$0.__')

where _ represents a blank.

If you want to show a negative sign with a negative number, include a sign
in the edit word.
Use either the minus sign (-) or the letters CR (credit) to the right of
the last digit replacement
character These print only if the number is negative.

Bonnie Lokenvitz


_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.