Understanding the Expected Value Column in CLM Queries

[former_member200421]

Introduction

The Expected Value Column that is returned in the results set of some of the Master Agreement List Queries is a calculated field based on metrics that are defined in the Savings Metrics tab of either a Master Agreement or Sub-Agreement.  The metrics are designed to track the expected value and the savings that will be realized as a result of a particular Agreement.  The Expected Value is entered for each of the metrics defined on an Agreement.  The value that is returned in the Expected Value Column is a total of all of the Expected Values that have been entered for each of the metrics defined in the Savings tab.

Note:  The Savings tab will only appear in either the Master Agreement or the Sub-Agreement but not in both if the Savings Metrics flag is enabled.  If Sub-Agreements are enabled, then the Savings tab will appear only on Sub-Agreements and not on Master Agreements.  This is defined on the Master Agreement Type in Setup.  

Savings Metrics Tab

You will find the Savings Metrics feature In the Features section of the Master Agreement Type definition as seen below:

If you enable this feature on the type, the Savings tab will be displayed in the Agreement – in the example below, it is displayed in the Sub-Agreement:

Savings Tab

In order to begin tracking Expected Value and related savings, the Savings Metrics for a specific time period must be defined as seen in the example above.  In this case, there are three time periods for which savings metrics have been defined.

Time Period 1

Time Period 2

Time Period 3

Expected Value – Sub-Agreements

The total Expected Value that is displayed for this single Sub-Agreement in the results set of the query is the sum of the Expected Values entered for the three time periods in the Savings tab:

Expected Value – Master Agreements

The total Expected Value that is displayed for this Master Agreement in the results set of the query is the sum of the Expected Values entered for all the time periods for all of the Sub-Agreements in the Savings tab:

Summary

In summary, this column is only one component of measuring value and savings related to Agreements; however, it does rely on the enabling the Savings Metrics feature in the Master Agreement Type definition and populating relevant metrics on the Agreements themselves.