SUM up of Amount per group

Welcome to mibuso..:D

there are couple of ways to do that in NAV but it depends on the requirements though.

- >group your report and put the variable Amount on the group footer use the createtotals function.

- > Create a function that return the sum of the amount.

Function GetSumperProductID(pID : Code[10]) : Decimal

YourTable.Setrange(yourTable.productpriceID,pID);
if yourtable.findset then repeat
 
 vLocVariable += yourTable.Amount;

until yourtable.next = 0;

Exit(vLocVariable);

.

3. do the search, there are many threads here like on your problem..