How to get the sum of a field in the line level of the grid and show in a header level field

Hi @malinthawarnakulasooriya08,

I have similar requirement before to get the Invoice amount total on Project billing screen

I did the following code on row selected event to get the same.

  var getBugetLines = PXSelect<PMRevenueBudget, Where<PMRevenueBudget.projectID, Equal<@P.AsInt>>>.Select(Base, row.ProjectID);

            if (getBugetLines == null) return;

            // Loop through the budget records and sum up the invoiced amounts
            foreach (PMBudget budgetRecord in getBugetLines)
            {
                // Retrieve the invoiced amount from the CuryAmountToInvoice field
                decimal invoicedAmount = budgetRecord.CuryAmountToInvoice.GetValueOrDefault();



                // Add the invoiced amount to the total
                invoicedAmountTotal += invoicedAmount;
            }
			 e.Cache.SetValueExt<ProjectsListExt.usrInvoiceAmountToPay>(row, invoicedAmountTotal);

You just need to use your DAC and Fields to get the Total Volume.

Let us know this will help you or not.

Regards,
Kumar