[SQL] what is the divisor is equal to zero in plsql?

SELECT pstartdate,
opbal,
joined,
resign,
( opbal + joined - resign ) clbal
,
( Round(( ( resign * 100 ) / ( opbal + joined ) ) / 100, 2) * 100
) attriation
FROM (SELECT pstartdate,
penddate,
Getopempbal(pstartdate) OpBal,
Getempjn(pstartdate, penddate) Joined,
Getempres(pstartdate, penddate) Resign
FROM (SELECT Add_monthsstartdate, LEVEL - 1) pstartdate,
Add_monthsstartdate, LEVEL) - 1 penddate
FROM dual
CONNECT BY LEVEL <= Months_between( :enddate, :startdate ) + 1))
ORDER BY To_number(1)


When i executed this query Error came

divisor is equal to zero.
​

i think error this place

(round(((resign*100)/(opbal+joined))/100,2)*100) attriation

Continue reading...