Add Data Calculations to a Sheet
- 13 Dec 2024
- 2 Minutes to read
- Contributors
- Print
- PDF
Add Data Calculations to a Sheet
- Updated on 13 Dec 2024
- 2 Minutes to read
- Contributors
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The way that you add calculations (such as a sum of values) to the form design depends on the output type of the sheet.
Refer to the information that corresponds to the sheet’s output type:
EMF-based output
You activate the calculation tool by clicking the Calculation button in the toolbar.
The calculation tool enables you to perform simple calculations with the data.
The available operations are described below.
For Conditional Rearranges
Calculation | Description |
|---|---|
Sum | Generates a script rearrange in the output calculating the sum of all values of the conditional rearrange. The rearrange is inserted below the end of the conditional area enabled for the current page type. |
Subtotal Current Page | Generates a script rearrange in the output calculating the sum of all values of the conditional rearrange on all pages up to and including the current page. The rearrange is inserted below the end of the conditional area enabled for the current page type. |
Subtotal Previous Page | Generates a script rearrange in the output calculating the sum of all values of the conditional rearrange on all pages except the current page. The rearrange is inserted above the beginning of the conditional area enabled for the current page type. |
Sum Group | Generates a script rearrange in the output performing the sum of all values of rearranges selected within a group. The script rearrange is inserted relative to the last instance of the group. |
Sum Region | Generates a script rearrange in the output performing the sum of all values of rearranges selected in one or more regions. You have the following options to insert the script rearrange:
|
For Multiple Absolute and Conditional Rearranges
Calculation | Description |
|---|---|
Add | Generates a script rearrange in the output calculating the result of the addition of all selected rearranges. The rearrange is inserted just below the bottom-most of the selected absolute rearranges and to the right of the selected conditional rearranges. |
Subtract | Generates a script rearrange in the output calculating the result of subtracting all selected rearranges from the first selected rearrange. |
Multiply | Generates a script rearrange in the output calculating the result of multiplying all selected rearranges. |
Divide | Generates a script rearrange in the output calculating the result of dividing the first selected rearrange by all selected rearranges. |
The generated script rearrange can be edited and further calculations can be added.
To run JavaScript, on the View menu, click Run JavaScript. Alternatively, press Shift+F5.
This rearrange has a specific format and Name properties are set automatically for selected rearranges if they have not been set before. The generally defined input format (see Set Up Data Formats (Regional Profiles)) is used for parsing input, and generally defined output format (see Sheet Options) is used for parsing output. It is also possible to override these settings on a rearrange basis, if needed.
Rich-text-based DOCX, PDF, and XHTML Output
You can use the Summary menu to add calculations. To do this, select a value in the column for which you want to calculate, for example, a sum of available values, right-click it and then select the required Summary type command on the context menu.
You can also sort data and group data.
You can also filter data in the table added to the output.
