I'm getting a divide by zero from the following select statement. The values
for tothrs and activity.standard are all positive real numbers, no zeros or
nulls. Does anyone have a clue as to why I'm getting this error.
Somehow tothrs/activity.standard is evaluating to 0 as shown below.
Select
t3t.*,activity.activity,activity.unitmeas,activity.standard,(tothrs/activity.standard)
AS standardunits,(units/(tothrs/activity.standard)*100) AS expectedunits FROM
t3t, activity WHERE t3t.activity EQ activity.activity and activity.standard <> 0
Tothrs Units Activity UnitMEas Standard
StandardUnits
1.5 1.5 033 Manh 1
0
2 2 032 Manh
1 0
6.5 6.5 941 Manh 1
0
4 4 520 Unit
0.83 0
6 11 520 Unit
0.83 0
10 20 520 Unit
0.83 0
3 3 028 Manh
1 0
5 130 526 LnFt
0.25 0
10 14 520 Unit
0.83 0
Dennis Hodges
Maintenance Management Manager
FDOT Office of Maintenance MS #52
PH: (850) 410-5635
FAX: (850) 410-5511
[email protected]<mailto:[email protected]>
As far as we know, our computer has never had an undetected error.
Please note: e-mail may be subject to public disclosure.
