You are here: Formula editor for "Custom Data Fields" and "Filters"
For more information on the formula editor, click here.
FAILED_CALCULATION
The calculation of your formula has failed. This error usually occurs when either invalid entries have been made or data required for the calculation is missing.
Troubleshooting:
Check whether you have selected all the required variables
Check whether the selected variables are correct
pay attention to the “type” of the data field (string or number)
INVALID_FILTER_RESULT
The formula does not produce a Boolean result, so it cannot be used as a filter.
A Boolean result is the result of a logical operation that can only have two possible values: true or false.
Troubleshooting:
Check whether you have selected all the required variables
Check whether the selected variables are correct
pay attention to the “type” of the data field (string or number)
SKU_NOT_AVAILABLE
The formula could not be processed. To be able to process a formula, at least one SKU must be available.
Troubleshooting:
Assign an SKU to your articles.
You can find more information about the SKU here.
DATA_FIELD_NOT_LOADED
At least one data field could not be retrieved from the database.
Troubleshooting:
Check your network connection
Check the connection to the database
EVALUATION_NOT_POSSIBLE
Formula cannot be evaluated; syntax and parameters are valid, but the formula still cannot be executed.
Possible causes and troubleshooting:
In the following example, the price is to be rounded to 2 decimal places. "String” was selected as the ‘Variable type’. This type cannot be processed with the desired function.
The “Variable type” must be changed to “Number”.
Check whether the selected variables are correct and can be processed with the function.
Pay attention here to the “Type” of the data field (string or number)
Further information on “Syntax, operators and functions” can be found here.
INVALID_CURRENCY
The currency is unknown.
Troubleshooting:
Check whether the currency is valid and has been specified in a machine-readable format.
ISO standard 4217: (EUR; USD; AUD; JPY; etc.)
Unicode: (
U+20AC= €;U+0024= $; etc.)html: (
€= Euro;$= US dollar; etc.)
INVALID_FORMULA_PARAMETER_NUMBER_FORMAT
The formula variable does not correspond to the correct type.
Troubleshooting:
Check whether you have selected the correct “variable type”.
Number: Select this option if the output data field only contains numbers.
Note: If you use period (.) or comma (,) as decimal separator, you can select the option “Number”.
String: Select this option if the source data field does not only contain numbers.
INVALID_FORMULA_PARAMETER_NAME
Reserved keywords are, for example, names of functions (here “clean_html”) or constants such as “Pi” or “true”.
Troubleshooting:
Assign a new name or change the spelling.
MISSING_FORMULA_PARAMETER
A variable declared in the formula is missing.
Troubleshooting:
In the example, the price should be rounded to 2 decimal places. However, the variable that defines the price is missing.
Define the variable “price”.
Pay attention to the correct spelling. The name of the variable must correspond to the name within the formula!
INVALID_FORMULA
The formula syntax is incorrect.
Possible causes and troubleshooting:
Brackets are missing within the formula
Check the formula for missing brackets
You are using a combination of formulas that are not compatible with each other
Split the formula or use other combinations
You are trying to divide by 0
CYCLIC_PARAMETER
The formula parameter refers to another parameter by circular reasoning. This means that a parameter indirectly refers to itself by referring to another parameter, which in turn refers to the original parameter.
Possible causes and troubleshooting:
Check your formula and the variables it contains.
UNKNOWN_FORMULA_ERROR
The calculation of your formula has failed due to an unknown error.