I am writing a series of reports that display averages and the number of
decimal places they extend out to is to large.
I thought I remembered some code to be able to accomplish this reduction but
I do not.
In the 1st place I believe my code for setting the var vAvgmchdt is wrong
and this may be the reason the next set var vRavgmchdt is not working and
only returns a text value of .
.vAvgmchdt
Please advise me where I have written this improperly.
Thanks for any help
____________________________________________________________________________
Code
sel average(timein-drivtime) from master where billstat ne 'nc' and +
breakdat between .vday1 and .vday2
Write ' '
Write ' '
set VAR vAvgmchdt = sel average(timein-drivtime) from master where +
billstat ne 'nc' and breakdat between .vday1 and .vday2
set VAR = (brnd(.vAvgmchdt, 5, .1))
Write 'AVERAGE DOWN TIME FOR ALL BREAKDOWNS FOR PERIOD SELECTED: +
----- ' .vRavgmchdt
____________________________________________________________________________
Results
DOWN TIME REPORT FOR ALL BREAKDOWNS REPORT -- PRINTED ON 02/16/03
START DATE: 01/01/02
END DATE: 01/01/02
average (timein
---------------
2.7467290334334
AVERAGE DOWN TIME FOR ALL BREAKDOWNS FOR PERIOD SELECTED: -----------
.vAvgmchdt
Elapsed Time: 0 seconds
____________________________________________________________________________
___________________________________________________________
Stephen Breen
CDI Services, Inc.
