Manage Field Formula


The formula definition -button will be available in settings. However if the a Dimension is selected for the field, then there will be no Formula defintion area nor button. If no formula for the field is in place the button is orange but if there is a formula the formula will turn green.

Clickin the -button will open/close the Formula definion area. A formula has to be valid Excel formula, using default international text and number settings: point (.) as decimal separator and comma (,) as parameter separator.

You can enter the formula either directly in setting formula field or in the Field in the SheetForm. In both cases you will check in the SheetForm, if there is any errors in the Formula.

Non-editable and hidden Fields

When Formula is defined for the field, you can select whether this calculated field is only available in reports and not visible when reporting. Checking the "Hide Field" -checkbox will keep the field hidden in Reporting but available in Reports. Checking the "Save as Value" -checkbox will show in reporting the calculated value as the default values, but the user can change the value. If "Save as Value" -checkbox is not checked, then user will not be able to make any changes to that field.

Refering to the Fields of the Table

You can refer to the other Fields of the Table by putting the name inside square brackets, like: [Value]. In order to refer other data in the database you need to use function: RX.DBGET, that is defined below.

Retrieve Database data

You can retrieve data directly from the database to the fields by using database retrieval-function:
RX.DBGET("Table-name", "Field-name", Period, ["Filter-field-name", Filter-field-value]...)

  • Table-name: name of the table wherefrom the data requested (RetriveTable)
  • Field-name: name of the field of RetrieveTable to retrieve result value from
  • Time-value: time of the data retrieved in Excel format (0 if no time specified)
  • Filter-field-name: name of the field in RetrieveTable to filter the result entry/entries
  • Filter-field-value: value required from this Filter-field

There can be multiple Filter-field pairs (-name and -value)