...
Name | Syntax | Explanation |
---|---|---|
Constant | "Constant text" | returns any text contained within " " **to include brackets () as part of constant text, each bracket must be preceded by - , e.g. " -(part á "&FORMAT(_vat_rate;0.00)&"% -)" **& symbol should be avoided as literal text wherever possible |
Variable | _field_value | returns value of field_value |
Mandatory | MANDATORY(_field_value) | field_value is mandatory and if no value given in raw data, file is not created and error is logged |
Format | FORMAT(field;format) | value of field will be formatted according to format Available Formats (for FORMAT() formula) 0.00 az09 → abcdefghijklmnopqrstuvwxyz1234567890 ddmmyy ddmmyyyy dd/MM/yy dd/MM/yyyy dd.mmMM.yyyy ddmmyyyy yy dd.MM.yyyymm.aaaa |
If | IF(logical_test;value_if_true;else) | if logical_test returns true, value_if_true will be returned (and analysed if it is a formula), otherwise else will be returned (and analysed if it is a formula) |
If error | IFERROR(value;value_if_error) | returns value if not empty/null, and if value=empty/null, value_if_error |
Or | OR(value_1;value_2;…;value_n);true_value;false_value | if any of the conditions (value_1, value_2, etc.) return true, returns true_value; if all of the conditions return false, returns false_value |
Concatenate | value_1&value_2&value_n | concatenates value_1 with value_2, etc |
Equal | value_a=value_b | returns true if value_a is equal to value_b, else returns false |
...