Calculate given formula and return result. Fieldnames are replaced with fields Field::getNumber() -value.

Example

Test values

price = 10

price_multiplier = 1.2.

Counts wrong:

'price * price_multiplier'  --> '10*10_multiplier' --> '100'

Counts correctly:

'price_multiplier * price'  --> '1.2*10' --> '12'

Return value

Float

Arguments

$formula

Calculation where field names are replaced with field values.

Subfield values can be referenced by: field.subfield.

Subrow sums can be referenced by: [fieldname: subfield]

$decimals

Number of decimals in return value

Default: 2

Full documentation

Count total from amount and price

$total $Order_row->calculate('amount * price');

Use subfield data: Count total from amount and product price.

$total = $Order_row->calculate('amount * product.price');

Use subrows sum:

$total = $Order->calculate('delivery_cost + [order_row: amount * product_price]');

Use of parenthesis:

$total = $Order->calculate('total * (100 - discount_percent) / 100 ');