calculate the total sum of the son entity's field

[lj4353]

I have created two entities, otherIncome and bonus, with a one-to-many relationship between them. I want to calculate the total sum of the amount field in the bonus entity and display it in the number field of the otherIncome entity.

[rabii]

easy, below the code you need to apply to the otherIncome entity formula:

if (entity\isAttributeChanged('bonusesIds')){
    number = entity\sumRelated('bonuses', 'amount');
}​ 

make sure that the names of the relationships are correct i just assumed that one otherIncome has many bonuses

[lj4353]

Great！problem solved

[zerosix]

but is this code will work after deleting or unlinking bonuses?

[rabii]

No it won't delete or unlink any bonuses.

[zerosix]

Hello Rabii, i mean is this code (formula) will work after deleting or unlinking bonuses?i think it's working just in save

[rabii]

hey zerosix

It should work if you have [Link Multiple Field] option enabled on your relationship otherwise it won't work and you will have to amend the code to something like below in order to work on both unlink and remove:

if (entity\countRelated('bonuses')) {
    number = entity\sumRelated('bonuses', 'amount');
} else {
    number = null;
}​