The Calculated control

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Overview of Calculated control

Control of a report

The "Calculated" control is used to perform calculations in a report. These calculations can be made:

Versions 18 and later

This type of control is now available for the reports in the iPhone/iPad applications.

New in version 18

This type of control is now available for the reports in the iPhone/iPad applications.

Versions 21 and later

This type of control is now available for the reports found in the applications in Universal Windows 10 App mode.

New in version 21

This type of control is now available for the reports found in the applications in Universal Windows 10 App mode.

Creating a calculated control

To create a "Calculated" control:

In the report editor:
- click .
- select "Insert .. New control .. Calculation".
On the "Creation" pane, in the "Usual controls" group, click "Calculation".
On the "Creation" pane, in the "Text" group, click "Calculation".
Click the position where the control will be created in the report.
In the wizard for creating the Calculated control, specify:
- whether the calculated control counts the records.
- whether the calculated control performs a calculation on an item or control. In this case, select the type of calculation (sum, average, ...) and the source for calculation (control name or item name).
- whether the calculated control displays a calculation performed by programming. In the list, select the mask to use.

This information can be modified in the description window of the control ("Description" from the popup menu).

Important: Difference between calculation and calculation on break

In the calculations on break, the control is re-initialized after each break.

Notes

Specific "Calculated" control: "Currency + Euro"

For a "Currency + Euro" Calculated control, you have the ability to manage:

the stored currency: currency of data found in the data source of report. If the control is handled by programming, the currency used for the value will be the stored currency.
the displayed currency: currency used to display the value in the report. This currency can differ from the stored currency. The conversion is automatically performed.
the dual display: two "Currency + Euro" controls can be linked. The value displayed in the base control is automatically converted in the tracker control.