Total a field from all related Quote Items and passing to parent Quote

[bgpus]

I have a field on all of my Quote Items that calculates the sqft of Height x Width (cItemSqft).

I would like to total all of the cItemSqft fields in the parent Quote (cTotalSqft) float field.

I have tried:

cTotalSqft = entity\sumRelated('quoteItems', 'cItemSqft');

cTotalSqft = record\sum('QuoteItem', 'cItemSqft', 'quoteId', id);

Still unable to get this working. Any ideas?

[lazovic]

Hi bgpus,

Please try using the following formula script:

 cTotalSqft = entity\sumRelated('items', 'cItemSqft');