Skip to main content



No record found.

Microsoft Dynamics CRM forum

Calculate Sum Amount of Selected Rows on Parent Entity

Posted on by 40

I have a requirement that on the selection of records in subgrid the amount denied should sum (for selected records only) and set in parent entity custom field and in case of unselection it should subract from the custom field.

Please see the image below for reference.


Any help will be appreciated.


  • RE: Calculate Sum Amount of Selected Rows on Parent Entity

    Hi Muhammad Ali,

    you can explore the OnRecordSelect Event and see if that fits your needs.

    As an alternative, I would also consider if an editable grid on the Bills subgrid with specific "flagging for sum" attributes could be also an option. You could use oob of the box rollup fields to sum up the "flagged" bills.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans