Translations:CSV Importing Guide/12/en
To create expressions in CSV files the following rules must be observed:
- The expression must begin with the equal character, be enclosed in parentheses and the columns enclosed in quotation marks. Examples: =("Price"/"Quantity"), =(("Profit"*100)/"Price")
- To reference other columns in the file, use the double-quoted column/header name
- It is not necessary to have data in the other rows for expression columns, as the content will be the result of the expression