Who is this article for?

Users who want to know more about the 12.0 metadata Calculation formula enhancements.

No elevated permissions are required.

The article discusses enhancements made to the Calculation element, allowing it to incorporate formulas driven by List items and display outputs with labels and colours alongside numerical values. These improvements offer users greater flexibility and visual clarity in their calculations within the system.

1. Overview
2. User guide
3. Further reading

1. Overview

The existing Calculation element has been improved upon to accept formulas driven by List items, with the calculation output now supporting labels and colours in additional to numerical values.

2. User guide

1. Each List item must be assigned a numerical Value to facilitate integration.

2. Use the established Calculation element to apply the defined value within the formula.
3. List items can be selected within the Formula settings by choosing Edit property.

4. Utilise drag-and-drop functionality to add elements from the left pane to the formula on the right. The example below highlights the List elements in use and a basic formula: 

5. The output of the calculation retains a numerical value but can feature custom labels.

6. Formula labels, though optional, can be assigned during the editing process to provide context to the output value.

Note: Should the formula require a standard numerical value output, this setting may remain as None.

7. When selecting Edit property, users can set threshold values and assign labels and colours as needed.
8. This feature, familiar to users of Annual Planning and Risk Assessment methodology, enhances flexibility in output presentation. The example below indicates the use of configured formula labels:

9. Required labels are quickly inserted or removed using the Add and Delete buttons provided.
10. Unlike Risk Assessment methodologies, there's no obligation for consecutive From-To values, offering enhanced adaptability in label application. This allows the user greater flexibility over the displayed output in instances where, for example, a specific result should not inherit any label at all. 
11. Users can observe the calculated results with the applied label and colour configurations.

3. Further reading

• 12.0 Entity Universe as a metadata element release notes
• 12.0 Entity Lock Management release notes
• 12.0 Grouping and column visibility release notes