Field Calculator syntax vb calculating slope percentage

Question

I am attempting to calculate the slope of sewer lines. I am apparently missing some fundamentals of vb to get the syntax correct. I have fields:
From_Invert
To_Invert
Length (calculated)

The mathematical equation (rise/run) should be something like this:

(([From_Invert] -[To_Invert])/[Length])*100 
I can't get it to fly in the field calculator. Any help would be greatly appreciated. 
Regards,
Dana

RobertBorchert · Answer

Null value would do it.  Glad it worked out for you.Robert, 
I ran it on one and it worked. I found a sneaky null value in the elevation fields! Thank you for all of your help talking me through this.Probably the easiest problem you've helped with today 🙂 
Thanks again!!!
Dana

DanaVan_Horn · Answer

Robert, 
I ran it on one and it worked. I found a sneaky null value in the elevation fields! Thank you for all of your help talking me through this.Probably the easiest problem you've helped with today 🙂 
Thanks again!!!
Dana

RobertBorchert · Answer

I will assume your Invert values are your elevations.

Are they also a double or integer?  As well as your length field

Have you verified that all the Invert and length fields have values.

Try this

((abs([From_Invert] -[To_Invert]))/[Length])*100

Select just one feature in your table and run it on just that.

For length are you using the shape length or a calculated length.

If you still get the error run it again but instead of using shapelenght put in some number like 150

Robert,
Thank you for your prompt reply. All of the fields are doubles.

I have attached a screen shot of the error I get when running the field calculator with the exact formula from my original post.

Thanks again,
Dana