Calculating Total Contract Value

[gauravk]

Hello, I'm looking for some help with calculating Total Contract Value in an opportunity. The calculation should be Amount Recurring x term + Amount-One Time

Under Opportunity Entity, I have already created the Term field TYPE ENUM (Month to month, 1yr, 3yr, 5yr) and a Total Contract Value as currency field - non-editable.

Looking for help on how/where I go from here to make the Total Contract Value do a calculation each time an opportunity has Amount Recurring & Amount one-time field filled in.

Thanks in advance for your insight.

[tanya]

https://forum.espocrm.com/forum/feature-requests/29437-time-tracking

[gauravk]

Hi Tanya - i'm not entirely sure what "Time Tracking" has to do with calculations unless you've responded with the wrong link?? Please, verify...Thanks!

[tanya]

Hi,
if I understand you well, the link is correct.
To calculate summation of some field of related records without developing, you need to use in Formula sumRelated function https://www.espocrm.com/documentatio...titysumrelated

But, if you want to update related records after target record saving, you need to have Advanced Pack with Workflow feature.
Or you can develop own hooks

https://www.espocrm.com/documentation/development/hooks/

[gauravk]

Thanks Tanya. I was able to create a workflow to complete the calculations.