total amount

Finance and Operations/AX Technical Forum
1

I have 4 fields in grid

Application number, price,qty,total amount

I have 5 records is there

outside of the grid I have one more filed is there amount

In grid what are total amounts are available to sum and display that in Outer field

can any one help me

2

table.field += table2.field;

3

Hi Ven,

You can use the below code example to return the sum of the TotalAmount field of all the records of Table2:

public Amount sumTotalAmount()

{

Table2 table2;

;

select sum(TotalAmount) from table2;

return table2.TotalAmount;

}

You can use the method sumTotalAmount () to assign this value to the field of Table1 accordingly.

Thanks & Regards,

Shankar Dutt Sharma