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

In the Field column, indicate the title of the employee field that you want to use in your personalized screen.

You can also set up a formula as a field (for example, Surname + Name). In that case, enter FORMULA in the Field column, then enter the formula in the Formula column. The result of a field or a formula (in other words, of a column) can be reused in another formula. To do so, enter F0 in the expression to be calculated followed by the number of the line that contains the field or the formula.

For example:

On line 2, a formula contains the base salary,
on line 3, a formula contains the Social security cap.

On line 4, the formula will calculate an expression in the form of: string$(F02<F03,"A")+string$(F02>=F03 & F02<2*F03,"B").

This formula edits the category (A or B) which the employee belongs to (category A if the employee's salary does not exceed the cap, category B if the employee's salary is comprised between the cap and twice the cap amount).