What is the definition of the StandardUnits column? If it is a whole
number with no decimals, you might have unpredictable results.
On 9/11/2014 10:17 AM, Hodges, Dennis wrote:
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.51.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.
