Subject: Re: AS400 Query and floating point decimal field From: mandis-inc@xxxxxxx Date: Wed, 21 Feb 2007 13:16:31 +0000 List-archive: List-help: List-id: MAPICS ERP System Discussion List-post: List-subscribe: , List-unsubscribe: ,

```Greg

As I understand it, The field is 32 position long and the number is displayed
as a single decimal with an indicator to the right to show how many position to
move the decimal to the left or right.

Field               Desc
Len  Dec
ITQTY           Transaction Qty                                        16    15

The display of the field in a query is below
1.100000000000000E+003

The +3 indicates to move the decimal 3 positions to the right.

So this value would be 1100

TIA

Mike
--
Best regards,

Mike Dreimiller
Mandis Inc.
410-526-5996
Mandis-Inc@xxxxxxx

-------------- Original message from "Greg Wenzloff" <GWenzloff@xxxxxxxxxxx>:
--------------

```
```Mike,

Perhaps I don't understand what you mean by floating point decimal.
If you mean it has many decimal places and you want to display or print
a value with only 2 decimal places then do:

Use Specify Report Column Formatting and change the decimal digits.

Or

Use Define Result Field and define a new field with 2 decimal digits and
display or print the new field.

Greg

-----Original Message-----
From: mandis-inc@xxxxxxx [mailto:mandis-inc@xxxxxxx]
Sent: Wednesday, February 21, 2007 7:19 AM
To: MAPICS-L@xxxxxxxxxxxx
Subject: [MAPICS-L] AS400 Query and floating point decimal field

I am writing an AS400 query. One of the fields is a floating point
decimal. How would I convert this floating point field to a regular
decimal (7.2. numeric)? The report writing tool is AS400 query.

TIA
--
Best regards,

Mike Dreimiller
Mandis Inc.
410-526-5996
Mandis-Inc@xxxxxxx
_______________________________________________
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.

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