Divide by Zero

[Guy007]

If I try to use division in a calculation field and the divisor is another field (say Field A), the whole program crashes if Field A is blank. I tried using an IF format IF(FieldA <> "", etc.) but no matter what form I try, a blank in Field A = CRASH. I'm using FM 3.0v3. Is there anyway to get around this? Thanks. Guy

[Louisa]

Hi,

I don't know if this would work with the way you have things set up, but why not set the default value of Field A = 1 so that it has the same non-effect on a calculation as a blank field but won't crash.

Louisa

[ZuperZZ]

Guy,

I think the IF function is the best solution, but instead :

IF(FieldA <> "")

try :

IF(IsEmpty(FieldA)=0,FieldB/FieldA,0) <If the field is empty the result is 1, if it contains some data =0. Knowing this you can define if perform the calculation or not>

ZZ

[This message has been edited by ZuperZZ (edited June 12, 2000).]

[LiveOak]

OBTW: The boolean way to express "IsEmpty(field)=0" is notIsEmpty(field).

[RoadBear]

Get 5! Its works correctly!!

[LiveOak]

FYI: A more technically correct use of IsEmpty() is:

If(IsEmpty(A), result1, result2)

or

If(notIsEmpty(A), result1, result2)

The first is equivalent to IsEmpty(A) = 1, the second to IsEmpty(A) = 0.

The IsEmpty() function already evaluates to a boolean true or false, there is no need to compare it to 1 or 0.

-bd