Skip to main content
Version: 2025 R2

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.
Example

Indicator

  • Bold – displays the returned value as bold text.

3. Security

Encode dangerous HTML tags – selecting this option results in encoding all HTML tags that are inserted as a value within a control and allow for initiating a JavaScript code (e.g., through an onclick attribute). The purpose of this configuration is to eliminate safety hazards caused by intentional or unintentional initiation of a JavaScript code.