1/ write formula into “Calculated Field x”
2/ click “Calculated Field x” button to add into export
3/ in “Calculated Field x” use same field name like XML tags (same name is displayed on mouse over button). Of course in you can use mathematical operators like + – * / brackets etc. Important – from version 2.3 all text fields should be enclosed in single quotes!!!
// invoice number with prefix and six digits
//export delivery company, if delivery company is empty will be exported first name + last name
('delivery_company' <> '') ? 'delivery_company' : 'first_name last_name'
// product price with tax per one product
// product price with tax for all same ID products in one order
product_price*(1+taxtaxrate/100) * product_quantity
// invoice date + 10 days
// wholesale price * 1.18 (included wholesale price of combination)
(combination_wholesale>0) ? combination_wholesale*1.18 : wholesale_price*1.18
// first name last name, all chars to upper case
// first name last name email, user format
'first_name'.', '.'last_name'.' ('.'email'.')'
(all text text fields and chars should be in single quotes and concatenated by dot)
'first_name, last_name (email)'
for this is Excel exist trick how forces the data to be text for example =”1.65″
Because double quotes are problem in calculated field, use this calculated field: chr(61).chr(34).’1.65′.chr(34)
For text fields can be used as well multiline field (without single quotes)