I am trying to take the result of a IF test and enter it in a global field. All I get is a 0 in the calc field if the result is true and nothing if it is false. Also nothing goes into the global field.

My formula: IF(X <0,Global=X,Global=0)

[This message has been edited by tomkaas (edited May 22, 2000).]

You have to use a script to assign a value to a global field. If you could define a global field as a calculation, how would it know from which record to take values?

In a calculation `=' always means comparison. There is no such thing as an assignment operator in a calculation. In fact, the entire calc is the right side of an assignment; the field name is on the left.