View Full Version : Expression problem


01-22-2005, 09:41 AM
I have an expression defined in field rules under the field called cost;


My result for example is .01811

When I add this to the end of the above expression;
if the freightunit is blank, my value is 0. If I put a 1 in the freightunit then my value is .01811
Sometimes there is no freight so nothing is entered in the freight and freighunit, so then my cost becomes 0. What can I do to the expression so I don't have to enter 1 in the freightunit when there is no freight? When I add freight and freightunit it works correctly.
What am I doing wrong?


01-22-2005, 10:10 AM
I fixed my problem, I'm not sure why, but I was dividing 0 by 0 and when you do that on a calculator you get an error. Anything divided by itself is 1 and 0 divided by 0 is not 1.
Here is my formula;



Al Buchholz
01-22-2005, 11:29 AM

Division by zero (mathematically) is undefined.

Your solution is the correct one to use.

Stan Mathews
01-22-2005, 12:37 PM
Not particularly important but since it appears that discount is a decimal (like .10)


could be