Revision as of 18:05, 7 August 2019
To create expressions in CSV files the following rules must be observed:
- The expression must begin with the character equal and be enclosed in parentheses. Examples: =(Price/Quantity), =((Profit*100)/Price)
- To reference other columns in the file, use the 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