Mapping calculated list item output values
You can map output values for calculated list item fields using the table lookup method. The table displays all possible input value combinations based on the fields you want to use in a calculation. Each combination can be mapped to a list value, which is returned as the output for the list item field. Use the table lookup to set up a calculation without using the scripting language.
Note: You can also use a formula to calculate list item outputs. See Adding calculated field formulas.
1. Select List Item as the Output type when adding a calculated custom field.
2. Select Table Lookup from the Calculated using list.
3. Select a Value list or click Setup List Items to create a new list. See Configuring custom value lists.
4. Click Edit to map the input fields.
The Edit Mapping dialog box opens.
5. Click Add Field to add an input field to include in the calculation.
The Add Field dialog box opens.
6. Select the field and click Add.
The field is added as a new column in the table.
7. Repeat steps 5 and 6 for each field to include in the calculation. You must add each field before mapping any values.
8. Select a row and select the Mapped Value to assign to the combination of field inputs.
Tip: Ctrl+click multiple rows and click Set Value to assign multiple fields at once.
9. Click Delete Field to remove a field from the table. Select the field to delete and click Delete.
Deleting a field clears all mapped values.
10. Select an Unmapped outputs default to value to specify the default value for combinations that are not mapped to an output value.
11. Click Test to test the configuration. See Testing calculated field formulas.
12. Click OK to save the mapping.
