The Formula Editor

OfficeReports contains a formula editor, which allows users to formulate the content of derived variables. When marking one of the following Categories or Variables the formula editor can be used edit the related formula:

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


Expressions 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: