@wgt issues
J. Ryan Kelley
ryan.kelley at trinitytransport.com
Mon Apr 18 05:02:28 PDT 2005
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,
--
J. Ryan Kelley
Trinity Transport, Inc.
More information about the Filepro-list
mailing list