I have the following code in an EEP. When the value of activity.standard=0 I
get a divide by 0 error. How can I correct this select statement?
CREATE view summ AS +
SELECT t3t.*, activity.activity, activity.unitmeas, activity.standard, +
(iff("activity.standard=0",0,(tothrs/activity.standard))) AS standardunits, +
(iff("activity.standard=0",0,(units/(tothrs/activity.standard)*100))) AS
expectedunits +
FROM t3t, activity +
WHERE t3t.activity EQ activity.activity
Also, when I try to open view sum, my system locks up and I can't do anything,
not even close R:Base. I have to end the process using the Task Manager.
I am running R:Base eXtreme 9.5 (32) Version 9.5.4.30626 and Windows 7
Enterprise Service Pack 1.
Dennis Hodges
Maintenance Management Manager
FDOT Office of Maintenance MS #52
PH: (850) 410-5635
FAX: (850) 410-5511
[email protected]<mailto:[email protected]>
Please note: e-mail may be subject to public disclosure.
