Data Conversion Errors
george.j.wen@us.abb.com
george.j.wen@us.abb.com
Mon, 19 Nov 2001 11:43:04 -0600
I'm on PH 6.07F (AS/400) but this question may be gereric enough.
I'm processing Revenue/Cost lines with a Margin Percent in Quiz.
Calcs and defines are pretty std. Vis:
def REVENUE-AMT float*8 = GLAA * -1
def MARGIN-AMT float*8 = REVENUE-AMT - SDECST
*************************************************************************
Footing........................
tab 77 REVENUE-AMT Subtotal trailing "-" pic '¬¬¬,¬¬¬,¬¬¬.¬¬ ' &
tab 94 SDECST Subtotal trailing "-" pic '¬¬¬,¬¬¬,¬¬¬.¬¬ ' &
tab 109 MARGIN-AMT Subtotal trailing "-" pic '¬¬¬,¬¬¬,¬¬¬.¬¬ ' &
tab 124 MARGIN-AMT Percent REVENUE-AMT trailing "-" pic '¬¬¬¬.¬¬¬ '
I don't get any errors on the report but the statistic cite them:
records selected : 100
** Data conversion errors: 220666
*************************************************************************
Revenue Amt Cost Amt Margin Amt Percent
34.88 270.00 235.12- 674.083-
927.75 7,237.11 6,309.36- 680.071-
390.68 3,224.88 2,834.20- 725.453-
971.14 8,559.20 7,588.06- 781.356-
163.89 1,897.75 1,733.86- 1057.941-
.00 1,560.00 1,560.00- .000
1,934.97 1,357.24 577.73 29.857
580.20 337.58 242.62 41.817
1,852.05 1,189.65 662.40 35.766
This sample contains some of the more unusual lines (warr) in the report
but there are no # signs to indicate data conversion errors and if I select to
avoid getting negative Margin Amt's there's no difference in the result.
Anyone have an idea of where to look?
Thank you in advance
George