Sum array issue

[Julio]

I have my CRM dashboard, where I have two menus. contracts and cases.
It turns out that I intend to attribute to the hour consumed the value of the sum of all contracts related to that contract.
as if it were the sum of the matrix of hours consumed in the case.
I've already tried adding in the entity manager the code: consumedHours =entity\sumRelated('Case', 'caseConsumedHour', 'name==stockHoursContracts'); but it doesn't work.
I ask for tips on how to do this sum correctly.

The images bellow will help you to understand the issue.

Thank you.

[lazovic]

Hi Julio,

Please attempt to use the formula script provided below:

consumedHours = entity\sumRelated('cases', 'caseConsumedHour');

Make sure that caseConsumedHour is the exact field name in the Case entity.

Also, please note that when you relate a new case to this custom entity, the consumedHours field value will not change. You need to either update the custom entity record manually so that the formula script is triggered (it only works after saving) or use the workflow: https://docs.espocrm.com/administration/workflows

[Julio]

The link you provided does not work.
The idea is that consumedHour updates every action that is made in the cases related to your contract (when changing the caseConsumedHour, when deleting a case, or when adding another case).
I have the workflows available, if it is possible to automate this, I accept the help.

[DashingUno]

Delete the last dot "." in lozovices link

[Julio]

Im using the formula that you provide, and it is working partially.

I will create a workflow to resolve situations where a case is deleted.
Do you have a ideia to solve that?

[Julio]

but it will not be possible to delete the consumed case because there is no workflow for this type of situation, so if there is a need to delete it, the person should just reset the hours in the related case.
I think the problem has been resolved.
Thanks