Using Calculated Fields

Calculated Fields allow you to use the values entered in other fields to be used to calculate the value of the current field. They are defined at the time you create or edit the fields in a category definition. You do this by selecting the Field Values line in the Add or Edit Field Screen as shown in the following example that creates a calculated Number Field.

1. To define calculated field, select Field Value from Edit Field screen.

1. To define calculated field, select Field Value from Edit Field screen.

2. Select Calculated Field From list.

2. Select Calculated Field From list.

3. Begin defining your calculated value by selecting first value, and then go through the other items.

3. Begin defining your calculated value by selecting first value, and then go through the other items.

4. You can specify a value.

4. You can specify a value.

5. Or you can select a field.

5. Or you can select a field.

6. Select the operation you want to perform and press Done.

6. Select the operation you want to perform and press Done.

7. Finally enter the second value or field.

7. Finally enter the second value or field.

8. The calculation should now be complete. Press Done.

8. The calculation should now be complete. Press Done.

9. The calculated field is now defined.

9. The calculated field is now defined.

Number fields allow you to create calculations on other number fields or nested categories. The options that are available are dependent on the type of field that is being defined. Here’s another example that creates a calculated Image Field.
1. Defining a calculated image field starts by selecting the Field Value and then Calculated Field on the next screen.

1. Defining a calculated image field starts by selecting the Field Value and then Calculated Field on the next screen.

2. You are then able to define test, which when true will display a chosen value.

2. You are then able to define test, which when true will display a chosen value.

3. Select to define the condition.

3. Select to define the condition.

4. Defining a test condition follows a similar path to defining a filter on a view.

4. Defining a test condition follows a similar path to defining a filter on a view.

5. Select the field to test.

5. Select the field to test.

6. Then select the condition to check.

6. Then select the condition to check.

7. And finally the value to test against.

7. And finally the value to test against.

8. The test is complete. Press Done.

8. The test is complete. Press Done.

9. You now should select Add Image to choose the image appropriate for the test.

9. You now should select Add Image to choose the image appropriate for the test.

10. After the image has been selected, the test is complete.

10. After the image has been selected, the test is complete.

11. Add further tests to the calculated image field.

11. Add further tests to the calculated image field.

12. When all tests have been added, the calculated image field is complete.

12. When all tests have been added, the calculated image field is complete.

Each calculated field contains a single expression. To create more complex expressions, you can build a calculated field using other calculated fields as arguments. Here’s an example that uses the number field we created above.
1. A calculated field can also be dependent on other calculated fields.

1. A calculated field can also be dependent on other calculated fields.

2. This shows an aggregate total operation being performed on the nested calculated field called Amount.

2. This shows an aggregate total operation being performed on the nested calculated field called Amount.

3. The calculated field definition is complete.

3. The calculated field definition is complete.

Because you may not want to show partial results in multi-step calculations you have the option to hide a calculated field.
1. When editing a calculation, select Hide Field if you do not want the field to be displayed.

1. When editing a calculation, select Hide Field if you do not want the field to be displayed.

When browsing the data entered into categories with calculated fields, the calculated fields are displayed in the same way as the other fields. However, when you edit an item the calculated fields are not shown until the item is saved.
1. Calculated fields are not shown on when adding or editing an item.

1. Calculated fields are not shown on when adding or editing an item.

2. You can only see them after the changes have been saved.

2. You can only see them after the changes have been saved.