add duplicate records in report

Business Central/NAV Developers Forum
1

Hi how do i add duplicated records together? For e.g in this list of data there are two values with the same external document no., i need to add the two values together to become 1 value.

I try:
Repeat
BaseAmt += Base;
Until table.next = 0;

But it adds up all the data value instead. Please help.

2

Which Version are you using?

Did you check GroupTotalFields property in report?

3

NAV 2009 r2. Do i need to put the external document no. inside the grouptotalfields property, but the external document no. is not a key.

4

You need to add it if you want to do grouping

5

Make sure your base report logic wont disturb with this chage…

6

I have add External Document no. into the GroupTotalFields property. Then the amount should be added in the group footer?

7

same post twice.

http://dynamicsuser.net/forums/t/62522.aspx