Calculated

Calculated field You can place a Calculated field to set a formula to display the calculated result.
In a formula, you can also use operators and functions to sum up other field values, or change the result depending on the conditions specified.
For details, refer to the pages listed in the Setting Formulas category.

Setting Formulas

For details on how to set formulas, refer to the following page.

Usage Examples

Described below are usage examples.

  • Four arithmetic operation: In a project management app, multiply the "unit price" by the "number of users" to calculate the sub total.
    Formula to calculate the subtotal: Unit_price*Number_of_users

  • Use a function in calculation: In a quote app or a transportation expenses reimbursement app, add itemized amounts to calculate the total amount.
    Subtotal: Unit_price*Quantity, Total amount: SUM(Subtotal)

  • Calculate working hours: In a time-clock card app, subtract the check-in time and the break time from the check-out time to calculate working hours.
    Working hours: Check_out_time - Check_in_time - Break_time*60

For other examples, refer to the Setting Formulas page.

Setting Options for Calculated Fields

Calculated field
  • Field Name
    • Specifies the header for the entry item.
  • Hide field name
    • Hides the field names on the screens to add, edit, enter details of, and print records.
  • Formula
    • To specify a formula, use field codes for the fields to calculate.
      If you change the field code in the field setting, the same change is applied to the field code that is being used in the existing formula.
      See "Setting Formulas"
  • Hide formula
    • Hides the formula in the Add records and Edit records screens.
  • Show As
    • Selects the display format of the calculated result.
  • Number of Decimal Places
    • Sets a specified number of digits after the decimal point to be displayed.
      The decimal part that exceeds the specified number of digits will be rounded down.
      Example of when "2" is set for the number of digits to be displayed
      Actual value Displayed Value
      1 1.00
      1.007 1.00
  • Currency
    • Specifies a unit symbol to be prefixed or suffixed to the field, such as "¥" or "meter".
      Unit symbols are displayed on the form, and also on the "Record List" screen and in the history.
  • Field Code
    • The text string to specify this field (in a formula or an API).