Calculate Sum Amount of Selected Rows on Parent Entity

(0) Share

Report

Posted on by mali93

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.

I have the same question (0)

All responses (1)

Answers (0)

Ioannis Vrasenikis Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No