---
title: "Add Data Calculations to a Sheet"
slug: "add-calculated-data-to-a-sheet"
description: "Describes how to add data calculations to a Lasernet Core form."
tags: ["Form Editor", "Lasernet Core"]
updated: 2026-04-15T13:33:03Z
published: 2026-04-15T13:33:03Z
canonical: "kb.lasernetgroup.com/add-calculated-data-to-a-sheet"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.lasernetgroup.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Add Data Calculations to a Sheet

You can perform calculations with input data and display the results in the form output.

The types of calculations that you can do with input data and how you do them, depends on the sheet’s output type.

Refer to the relevant following information:

**EMF-based output (Lasernet Core 11, Lasernet Core 10, and Lasernet Essentials / Professional / Advanced)**

You activate the calculation tool by clicking the **Calculation** button in the toolbar.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/calculation 1.png)

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: - Insert sum after any selected region. - Insert sum after any region containing selected object names |

### 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)](/v1/docs/set-up-data-formats-regional-profiles)) is used for parsing input, and generally defined output format (see [Sheet Options](/v1/docs/sheet-options#format)) 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 HTML/XHTML Output (Lasernet Core 11 and 10 only)**

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.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/rich text 4.png)

You can also sort data and group data.

You can also filter data in the table added to the output.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/rich text 5.png)