Calculated

Article Number:040517

"Calculated" fields allow you to set a formula and display the result of the calculation.
Using operators and functions in your formula, you can sum up values of other fields, display different values based on conditions, and so on.

Screenshot: Example of a "Calculated" field

"Calculated" field settings

Screenshot: The settings of a "Calculated" field.

Name

Specify the field name. The field name is displayed as the label of the field in the app.

Hide field name

Selecting the Hide field name checkbox hides the field name on the following screens.

  • The "New Record" screen
  • The "Edit Record" screen
  • The "Record Details" screen
  • The screen for printing a record
  • The Form settings screen

Formula

Set a formula using field codes of the fields whose data you want to perform calculation on.
If a field code is changed in the field setting, the change is automatically applied also to the field codes used in formulas that are already set.

For details on how to set and use formulas, refer to the following page.
Setting Formulas

Hide formula

Selecting the Hide formula checkbox hides the formula on the following screens.

  • The "New Record" screen
  • The "Edit Record" screen
  • The Form settings screen

Display format

Select the display format of the calculation result.

Number of Decimal Places to Display

Specify a fixed number of digits to display after the decimal point.
If a value has more decimal places than the specified number, those decimal places will be truncated.

For example, if "2" is specified as the number of decimal places, numbers entered in the field will be displayed in the following way.

  • If the calculation result is "1", the field will display "1.00".
  • If the calculation result is "1.007", the field will display "1.00".

Unit of measure

Specify a unit to be displayed before or after the field (e.g., "$" or "yard").

Field Code

The character string used for specifying the field in APIs.

Usage examples

Use a "Calculated" field when you want to have the values of multiple fields automatically calculated.

For example, the "Calculated" field can be used in the following ways.

Calculate a subtotal by multiplying a unit price by a number of users

In this example, the "Unit Price" field value is multiplied by the "Number of Users" field value to automatically calculate the value in the "Subtotal" field.
The following formula is set in the "Subtotal" field.

The content has been copied.
Unit_Price\*Number_of_Users

Screenshot: Using a "Calculated" field to automatically calculate a subtotal

Calculating a total price by adding up subtotals

In this example, a price quotation's "Total Price" field value is automatically calculated by adding up the "Subtotal" field values in the statement.

The following formula is set in the "Subtotal" field.

The content has been copied.
Unit_Price\*Quantity

The following formula is set in the "Total Price" field.

The content has been copied.
SUM(Subtotal)

Screenshot: Using "Calculated" fields to automatically calculate subtotals and a total price

Calculate working hours

In this example, the value of the "Working Hours" field is automatically calculated based on the values in the "Start", "Finish", and "Break" fields.
The following formula is set in the "Working Hours" field.

The content has been copied.
Finish-Start-Break\*60

Screenshot: Automatically calculating working hours