Calculated text value
The field displays the value found in the first column of the first row from the query result. This value is stored in data base.
1. Source column
The selection list allows you to indicate a database column from which values are inserted into a data row.
2. Display mode
-
Text – displays the returned value as text.
-
Percent – the value is displayed as a progress bar along with a percentage. In order to work correctly, the returned value must be a number between 0 and 100.
-
Indicator – the displayed value is replaced with an indicator whose color depends on the value that was returned:
- lesser than or equal 0 – red,
- equal 1 – yellow,
- greater than 1 – green.
-
Bold – displays the returned value as bold text.