LinkedIn
Copied!

Table of Contents

Creating a calculated field

Version:

Only available versions of this content are shown in the dropdown
Applicable to Theme Cosmos applications

Save time and improve the accuracy of the information that your case processes by creating a calculated field. For example, configure a Total Time field to generate a subtotal from a list of time sheets.

  1. Navigate to a place where you want to add a calculated field:

    Choices Actions
    Add a calculated field to a case type in App Studio
    1. In the navigation pane of App Studio, click Case types, and then click the case type that you want to open.

    2. Click the Data model tab, click Add field.

    Add a calculated field to a case type in Dev Studio
    1. In the navigation pane of Dev Studio, click Case types, and then click the case type that you want to open.

    2. Click the Data model tab, click Add field.

    Add a calculated field to a data object in App Studio
    1. In the navigation pane of App Studio, click Data.

    2. Click the data object that you want to open.

    3. On the Data model tab, click Add field.

    Add a calculated field to a data type in Dev Studio
    1. In the navigation pane of Dev Studio, click Data types.

    2. Click the data type that you want to open.

    3. On the Data model tab, click Add field.

  2. In the dialog box, in the Field name field, enter the name of the new field.

  3. In the Type field, select a field type that supports calculations.

    If a type supports a calculation, the This is a calculated field (read-only) check box is displayed in the Advanced section.
  4. Expand the Advanced section, and then select This is a calculated field (read-only).

  5. In App Studio, for any type of a calculated field, you can use a decision table to calculate the field value by selecting Decision table in the Calculation list.

    For more information, see Calculating values with decision tables.
  6. For the Integer, Currency, Percentage, and Decimal fields, define a calculation by calling a function or referencing a property.

    To call a function when the field stores a numeric value:
    1. In the Calculation section, select an option, other than Custom, from the Function list.

      You can calculate an average or find a maximum value.
    2. In the Field list, select a single-value field that is defined in a repeating field group.

    3. Click Submit.

    To reference a property from a numeric field:
    1. In the Function list, select Custom.

    2. In the Calculation field, press the Down arrow key to choose a property to reference.

    3. Click Submit.

  7. For Text (single line), Text (paragraph), Boolean, Date & time, Date only, Email, Phone, Time only, and URL fields, define a calculation:

    1. In the Calculation field, press the Down arrow key to choose a property to reference.

      To concatenate multiple text properties, use a plus sign.
      [property.name] + [property.type]
    2. Click Submit.

  8. Click Save.

Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.