How to calculate TCV (total contract value) in PostgreSQL

Make the most of your PostgreSQL data

What is TCV (total contract value) ?

TCV (total contract value) is the total value of the contract. This includes all contract no matter their duration, so if you have signed a contract for 1 month and one for 1 year the TCV will be the sum of all contract value. Make sure TCV also includes the value from one-time charges, professional service fees, and recurring charges.

What is PostgreSQL ?

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

How to calculate TCV (total contract value) in PostgreSQL ?

It can be difficult to calculate TCV (total contract value) directly inside of PostgreSQL; that's where Whaly comes in.

Whaly helps you build models on top of PostgreSQL and many other solutions. You simply connect Whaly to your PostgreSQL account, and then you can create your formula in Whaly to calculate your TCV (total contract value).

How does Whaly work ?

Self-Service Business Intelligence

Our self-service exploration tool is designed with business teams in mind, with the goal of empowering non-technical users to answer their own data questions and run queries autonomously. Our familiar, intuitive, drag & drop experience maximizes adoption across the business, leading to more data-driven decisions.

Visualize your data

Free trial Request a demo

Discover how to visualize data

Declarative Modeling

Our modeling workbench is tailored to data teams, allowing them to implement business logic, create the semantic layer, and model data from different sources using SQL. Our bespoke tool enables data teams to set up a solid data foundation that can be easily governed as you scale.

Build your metrics

Free trial Request a demo

Discover how to model data

Get up and running ASAP

Whaly comes with some quick-start ETL connectors included with our platform, to help you get up and running in record time. For connectors that we don’t offer, we’ll connect you to your best-suited ETL partner to ensure that your BI projects are always complete.

Free trial Request a demo

Discover our ETL

Calculate Bookings in PostgreSQL Calculate SaaS Revenue in PostgreSQL Calculate ARR (annual recurring revenue) in PostgreSQL Calculate ARR per customer in PostgreSQL Calculate MRR (monthly recurring revenue) in PostgreSQL Calculate Gross Profit in PostgreSQL

Calculate TCV (total contract value) in PostgreSQL Calculate ACV (annual contract value) in PostgreSQL Calculate Lifetime value in PostgreSQL Calculate Gross churn in PostgreSQL Calculate GMV (gross merchandise volume) in PostgreSQL Calculate Marketplace Revenue in PostgreSQL

Benoit Prigent

Benoit Prigent

Co Founder / CPO @ Lokki

Whaly helped us create metrics on top of 6 data sources in a matter of days instead of months without technical knowledge required !!

Edouard Mascré

Edouard Mascré

Co Founder @ Pennylane

We leveraged Whaly on the Sales team to build and share dashboards with ton of partners without having to continuously update things on many spreadsheets. It also gives us deeper insights on sales activity. The dashboards built can be shared with everyone in the company. Whaly saves us hours of data wrangling every day.

Benjamin Cambier

Benjamin Cambier

Co Founder @ Mansa

Mansa grew really fast in the past months and we were in urge of more precise metrics, especially for acquisition and deals analysis. Our engineering team was already swamped so we started our data analysis with Whaly. We compute our CAC per acquisition channel and understood at what stage the pipeline is under performing in minutes.

Quentin Lebret

Quentin Lebret

VP Operations @ Klox

Whaly gave us the tools to understand how our users consume our product and helped us create a better experience for our users.

Julio Cesar Rodriguez

Julio Cesar Rodriguez

Operation Automation Specialist @ Career Karma

Whaly helped us create actionable experience for our SDR based on data our data team has prepped for us in dbt.

Hugo Cornu

Hugo Cornu

Head of Growth @ Klox

Whaly helped us transform the way we work with data. We now back all our decision with data and can make informed decisions at any time