Re: Query/400: Adding % sign to Report

[<aldg3@xxxxxxxxxxx>]

Hi Dale Gindlesperger and Bonnie Lokenvitz:

Thank you for your postings.....your suggestions worked.

Have a good weekend.  You can do that by going out to listen to some live 
music!  :-)

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


> From: DaleGindlesperger@xxxxxxxxxxx
> Date: 2004/03/19 Fri AM 10:24:58 PST
> To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
> Subject: 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
> 


> From: Bonnie_Lokenvitz@xxxxxxxxxxxxxx
> Date: 2004/03/19 Fri AM 09:05:48 PST
> To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
> Subject: Re: Query/400: Adding % sign to Report
> 
> 
> 
> Try '999.99%'  where you replace the 9's with blanks.
> 
> Bonnie
>