The Formula Editor

OfficeReports contains a formula editor, which makes it easier to create formulas for derived variables. The formula editor can be used edit the formula for:

  • Categories in derived categorical variables
  • Derived numeric variables
  • Derived date variables

Formula Editor Form


Formulas for categories have to result in a boolean value (true or false)! If an expression resulting in a boolean value is used for a numerical derived variable, true will result in value '1' and false will result in value '0'.


Below we will explain how to reference categories and variables and which operators you can use: