Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

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.

2020_2D00_11_2D00_13-14_5F00_48_5F00_51_2D00_C_5F005F00_Users_5F00_maliv_5F00_Quire_5F00_Screenshots_5F00_2020_2D00_11_2D00_13-14_5F00_45_5F00_40_2D00_Claim_5F00_-Claim_5F00_-890776-_2D00_-Dyna.jpg

Any help will be appreciated.

TIA.

  • 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.

    docs.microsoft.com/.../grid-onrecordselect

    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 . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans