This article explains how to get the details of TCV of a charge from the SubscriptionDetails file.

1. Filter the spreadsheet by the Subscription Code column to show only the desired subscription.
2. (optional) To more easily locate the rows for the desired charge you can add additional column filters. For example, filter by Charge Type to show only the relevant type of charge (One-Time or Recurring), and Product to show only the relevant product name. You can also refer to the Effective Start and Effective End columns to trace renewals and amendments.
3. To calculate the TCV for a recurring charge, add up the TCV values for all the sections of that charge. The TCV values for every one-time charge and section of a recurring charge in the subscription are in the TCV column.