Field help (EXP1) @ L.V. Expertise X3

This optional field is used to enter the expression corresponding to a selection of assets included in the processing.

An expression is a calculation formula defined in an algebraic language.

They can contain :

numeric constants, for example 3.1415926
character string constants, for example "HELLO"
date constants, for example [15/03/1966]
operators, such as the algebraic operators + - / * or the comparison operators < > <= >= = <>
functions such as min,max,sum,sqr...
variables designated by their name, for example MAVARIA
fields extracted from tables, for example [F:BPC]BPCNAM
an unlimited number of brackets

The entry of an expression can be facilitated thanks to the buttons that are used to call the different functions available, or to recover the fields in the tables by a search of the data dictionary. An expression can give a result in the form of a character string, numeric results, a date or logical value (true if the result is not blank, false if the result is blank). The expression type expected depends on the place where the formula is entered.