@wgt issues
Howie
howiewz at beonthenet.com
Mon Apr 18 08:15:08 PDT 2005
----- Original Message -----
From: "J. Ryan Kelley" <ryan.kelley at trinitytransport.com>
To: "fplist2" <filepro-list at seaslug.org>
Sent: Monday, April 18, 2005 8:02 AM
Subject: @wgt issues
| I'm in the process of writing a report with several dummy variables.
| Throughout the report, i'm accumlating a dollar ammount to be displayed
| in the grand total section of my report with along with a profit %
| calculation. For some reason, whenever running this report, the grand
| total dollar ammounts are showing up as .00, so to debug I put my
| accumlating dummy fields in the subtotal fields as well, just to see
| where I was going wrong. Oddly enough, the values of the dummy
| variables in the subtotal fields are fine, accumlating perfectly, for
| some odd reason when I get to the grand total section of the report they
| show up blank. Even more oddly, I have another set of dummy variables
| that I'm accumulating throughout the report, and they display just
| fine. I'm running the report w/ no automatic processing and am at a
| loss for where to go next, has anyone seen a problem like this
| previously and managed to work around it.
|
|
| Here is an example of what i'm getting in my output
|
|
| Customer : ABC
| On Time Pickups: 5 - 100% Gross Sales - $1000
| ($1000)
| On Time Deliveries: 5 - 100% Gross Profit - $200
| Average Profit - $40 20% ($200)
|
| Customer : XYZ
| On Time Pickups: 9 - 90% Gross Sales - $2000
| ($3000)
| On Time Deliveries: 10 - 100% Gross Profit - $500
| Average Profit - $50 25% ($700)
|
|
| Grand Total
|
| On Time Pickups 14 -93.3% Gross Sales - $.00
| On Time Deliveries 15 - 100% Gross Profit - $.00
| Average Profit - $.00 /D0 %
|
|
|
| The dummy variables for on time pickups and deliveries accumulate, and
| display with no problem. The gross sales/profit columns accumlate
| throughout the report, and are displayed in the parens, but when it
| comes to the grand total, they somehow get blanked out. And my @WGT
| code doesn't even touch the gross sales & gross profit values, it only
| attempts to generate the average profit and average profit margin.
|
| the dummy variables are declared as follows
|
|
| js(12,.2,g) ' gross sales
| jp(12,.2,g) ' gross profit
|
| Any Ideas would be greatly appreciated,
|
I've run into this exact symptom when variables are declared in a separate
automatic processing table but rcabe was not told of the override to the
automatic table at the time the processing was compiled.
If that is indeed the case use rcabe from the command line with the -t
newauto flag.
Howie
More information about the Filepro-list
mailing list