@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