my code does not seem to work I get an error saying "expected end statement"
Pre Logic:
dim invert as double
if ( [CALGIS_SANITARY_PIPE.UP_INVERT] = 0 or [CALGIS_SANITARY_PIPE.DN_INVERT] = 0) then
invert = Max([CALGIS_SANITARY_PIPE.UP_INVERT], [CALGIS_SANITARY_PIPE.DN_INVERT])
elseif ( [CALGIS_SANITARY_PIPE.UP_INVERT] = 0 and [CALGIS_SANITARY_PIPE.DN_INVERT] = 0) then
invert = 0
else invert = Min([CALGIS_SANITARY_PIPE.UP_INVERT], [CALGIS_SANITARY_PIPE.DN_INVERT])
end if