SIGNEDON

Syntax:

(N value) SIGNEDON boolean_expression

Return Value:

N result

Precedence:

Changes the sign of a number if the Boolean expression is FALSE

Description:

 

Example:

If ORDER_VALUE is 4.23 then ORDER_VALUE SIGNEDON (DR/CR='CR') has the value:

  • +4.23 if DR/CR='CR'
  • -4.23 if DR/CR='DR'

where DR/CR is a field that defines whether the order is a Debit or Credit