Skip to main content
Version: 2023 R3

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.

./img/CalculatedText.png

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.