Formulas can consist of references and constants separated by operators. The value of a formula is calculated from left to right; they are left associative.

Operators are used with references and Axel-f functions. Here is a very simple illustration of the use of operators ( + ) with references.

modelbyid.base_price + enginebyid.body.price + dealer.body.discount

Operations are grouped from the left. Any field expression can be used as an operand for an operator.

MAP(FN(x, ROUND(x * 1.1, 2)), allvariants.body.[].base_price_EUR)

When more than one operator occurs in an expression, it is evaluated based on order precedence. In general, arithmetic operators are evaluated first followed by comparison operators. To change a precedence of operators, enclose in parenthesis the part of the formula to be calculated first.

• ((2+2)*2 => 8)

Operator types valid in Xapix include:

• .(dot) operators

• Array operators

• Arithmetic operators

• Concatenation operators

• Comparison operators

• Logical operators

Example

Suppose we create an endpoint parameter called total_price. For this parameter, two references and an operator are used to resolve to the value we want:

• findvariantbyid.body.base_price_EUR

• findenginebyid.body.price

We first create an endpoint parameter called total_price. In the Endpoint unit, expand body, then click New Property.

In the New Property field, enter total_price, click Literal and then Create.

Expand total_price, then in the dark green area click Set Formula to open the Formula editor.

In the Formula editor, enter the following, then click Save:

findvariantbyid.body.base_price_EUR + findenginebyid.body.price

If you have entered the formula correctly, a Formula valid message appears. Click Save.

The resolved value appears under the endpoint parameter name, total_price.

Array operators

Arithmetic operators

Concatenation operators

Comparison operators

Logical operators