Re: Query/400: Adding % sign to Report

Try using this for an edit word:

'xxx.xx%' where every 'x' is actually a space.  You have to leave a space
in the edit word for every digit in the numeric field.  Since the field you
mentioned has a length of 5 with 2 decimal positions, you have to have 5
blanks in the edit word.  Query/400 will fill in the blanks with the actual
digits in the field, automatically doing a decimal point alignment.

In that case, the field with 10000 in it will show 100.00%.   05000 will
show as 50.00%.

Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA  15501




                                                                                
                                                        
                      <aldg3@xxxxxxxxxxx                                        
                                                        
                      >                         To:       
<mapics-l@xxxxxxxxxxxx>                                                       
                      Sent by:                  cc:                             
                                                        
                      mapics-l-bounces@m        Subject:  Query/400: Adding % 
sign to Report                                            
                      idrange.com                                               
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      03/19/2004 11:58                                          
                                                        
                      AM                                                        
                                                        
                      Please respond to                                         
                                                        
                      MAPICS ERP System                                         
                                                        
                      Discussion                                                
                                                        
                                                                                
                                                        




Hi group:

I hope this posting isn't too off point for the Mapics ML.

I have a query that reports a % variance in one of the report columns.

On the "Specify Report Column Formatting" page, the column settings are
shown as:

Field: PCCHANGE

Column Spacing: 2

Column Heading:

ISS
VAR
 %

Len: 5

Dec: 2

Therefore, the report shows various amounts such as: 100.00, 50.00, etc.

How can I use the Edit Word function (F16 Edit) so the Report shows:
100.00%, 50.00%, etc.

I tried reading the "Specifying Edit Word" section of the IBM Query/400
manual but I couldn't get a good understanding of how to implement this
function.

When I try, I get the Error message: "EDIT WORD DOES NOT MATCH FIELD
LENGTH."  I change the field length and the message still shows up.

I look forward to your assistance.

Regards,
Al Gershen
Cost Accountant Lead
ECS Composites
Grants Pass, OR
aldg4@xxxxxxxxxxx





_______________________________________________
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.