Translations:CSV Importing Guide/12/en

From TaticView
Revision as of 13:44, 15 October 2019 by FuzzyBot (talk | contribs) (Importing a new version from external source)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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