topic Re: ACV automatic calculation in Tips, Tricks & Best Practices

ACV automatic calculation

SarahOps — Tue, 28 May 2024 09:28:38 GMT

Hello,

Wondering if anyone can think of a solution to the below problem:

I created a custom property to calculate ACV using a formula. The issue I face is that we sometimes have contract durations of less than 12 months. When that is the case, the ACV is not calculated properly. I'm including a screenshot of this scenario below.

Thanks

Re: ACV automatic calculation

Lucila-Andimol — Tue, 28 May 2024 10:02:31 GMT

Hey @SarahOps

I think that fi your TCV is the total cost of the proyect your formula should be TCV/12

this way you always take the TCV to a monthly amount

Its the same if you do the first 6 months with an X amount and the the other six month at 0 amount.

If the TCV is monthly (like MRR), then your formula should be (TCV*Contract term)/12.

Hope this helps

Re: ACV automatic calculation

SarahOps — Tue, 28 May 2024 12:25:05 GMT

Hi @Lucila-Andimol , TCV is the total contract value. Some of our contracts are multi-year so TCV/12 would not work....

Re: ACV automatic calculation

Lucila-Andimol — Tue, 28 May 2024 12:35:43 GMT

In this case you should have a deal per year of contract

to get the proper info in reports and also be able to make this in this property work

because as you mentioned before you are trying to get the Annual Contract value

The other option is to consider recurring revenue (in Enterprise)

Hope this helps