How to add up the product values and display them in the monthly cost field?

[pdnthiago]

Guys, could you guide me on how to perform the sum calculation?

In the example image circled in blue, there are the items that the customer has.

How can I make EspoCRM take the monthly cost values circled in blue and, every time I change, add a new item, or delete an item, automatically sum the values and place the total in the monthly cost field circled in red?

I need the sum to be only for the total of items for that specific customer, since each customer has different items and values.

I have the Advanced Pack.

[emillod]

Hello,
you can display a report in panel under specific entity with amount or if you'd like to load this information into field, you have two ways. You can use afterRelate hook or you can use notStorable field. Unfortunately, both ways requires coding. The easiest would be to use report panels: Reports - EspoCRM Documentation

[dreginald]

You can create another related Entity and bring the Analytics using ReportFilters with appropriate formulae