I may have this wrong, but based on the @IF funtion from the help, you may not be able to do this the way it is presently set up
The @If statement has an odd number of parameters with a minimum of three, as follows:
The condition is the first parameter and every other parameter thereafter if the @If statement has multiple conditions.
The statement that is executed if the condition is True is the second parameter and every other parameter thereafter if the @If statement has multiple conditions.
The statement that is executed if the condition is False is the last parameter.
The simplest @If statement has the following syntax:
@If(condition; True statement; False statement)
An @If statement with three conditions has the following syntax:
@If(condition1; True1; condition2; True2; condition3; True3; False)
The @If function is evaluated left to right, and the first condition that is True causes its corresponding True statement (that is, the next parameter) to be processed. No further evaluation or processing within the @If statement takes place. If none of the conditions are True, the False statement (that is, the last parameter) is processed.
The True and False statements take various forms, depending on their context:
If the @If statement is the last statement in a formula that evaluates to a result, the True and False statements must evaluate to a result.
If the @If statement is the righthand side of an assignment, the True and False statements must evaluate to a value suitable to assignment to the field or temporary variable on the left side.
Otherwise, the True and False statements must cause an action.
A True or False statement in @If cannot contain an assignment. The left side of an assignment can occur only at the beginning of an outermost statement in a formula. The following syntax is illegal:
@If(condition; variable := value1; variable := value2)
You must write it as:
variable := @If(condition; value1; value2)
Main Topics
Browse All Topics





by: SysExpertPosted on 2006-07-27 at 10:15:33ID: 17194648
Strange ?
What version of CLient and Server ?
Are the parenthesis correct in the formula ?
I hope this helps !