System Administrator Scenarios › How to Create a Custom Object › Create Attributes › Create a Formula Attribute

Create a Formula Attribute

Create a formula attribute to calculate the weighted average of two or more attributes in the same object. This attribute is similar to a calculated attribute, but you can build a weighted average. For example, the value for the Risk Drivers attribute is based on the Risk Likelihood and Risk Priority attributes with Risk Likelihood weighing twice as much as Risk Priority.

Follow these steps:

1. Open Administration, and from Studio, click Objects.
2. Click the name of the object.
3. Click Attributes.
4. Click New.
5. Complete the requested information. The following fields require explanation:

   Partition

   Specifies the partition to associate with the attribute.

   Partition Association Mode

   Specifies which partitions can include the attribute, in addition to the selected partition.

   Data Type

   Defines the data type for the field. Select Formula.

   Decimal Places

   Defines the number of decimal places to return for the attribute. To specify the attribute as an integer, enter a zero (0).

6. (Optional) To display the field in color or as an icon, complete the following steps in the Display Mapping Section:
   1. In the Type field, select Color or Icon.
   2. Select the appropriate color or icon.
   3. Enter a brief description of the color or icon representation in the Description field.
   4. Enter a number for the beginning of the range that the color or icon represents in the From field.
   5. Enter a number for the end of the range that the color or icon represents in the To field.

   Repeat this step to define any other ranges of numbers to color-code or represent by an icon.

7. Click Save.
8. In the Formula field, click [Build Weighted Average Formula] to add a weighted average formula.
9. Complete the following fields:

   Attribute

   Specifies the attribute that you want to give consideration in the weighted average calculation.

   Weighting

   Specifies the value to multiply by the value of the attribute you selected to compute the weighted average for a row. The product adds the weighted values from all rows and computes the average. The entries that you make in the Weighting column prioritize the attribute over other attributes when calculating the weighted average. If you leave the Weighting column empty, an ordinary arithmetic average is computed.

   Example: weighted ave=[(Risk * 4) + (Customer Satisfaction * 2) + (Alignment * 1)] /3

10. To add weights to additional attributes, click New Row for each attribute.
11. To see if the formula for the weighted average works as expected, click Recalculate.
12. Save your changes.

    The page displays the formula results in the Test section.

Back to Top