get the sum of column in a grid and add to the header level

@Dioris Aguilar 

Thanks for the response, your solution worked. But sometimes I need to change this A field value by own instead of the default value, after changing the value, other columns also need to change accordingly. For that I used fieldUpdated event for the A field and added the below code.

//calculate total amount in header and details level

decimal? amount = this.APProformaItems.Select().FirstTableItems.ToList().Select(x => x.Amount * x.ProFormaQty).Sum();

item.DetailTotal = amount;

decimal? LineAmount = row.ProFormaQty * row.Amount;
row.TotalAmount = LineAmount;

This time line level is okay but the header value total amount (D) is not changed accordingly. I need D filed to change into 0 just after editing the A and update with the new total.

Can you help me to accomplish this scenario as well?

Thank you.

@oshadarodrigo64 That scenario should be handled by the same PXFormula attribute. Please, confirm that field C is defined after field A & field B in the DAC class and field A and field B have commitchanges=true in the aspx.

Hi, just a comment but if you want to use [PXFormula(typeof(Mult<fieldA, fieldB>), typeof(SumCalc<Header.fieldD>))] , do the fields have to be created in the database or could they be PXUnbound fields?

Thanks