# Problem in sum calculating inside 2013 report

**URL:** <https://www.dynamicsuser.net/t/problem-in-sum-calculating-inside-2013-report/48498>\
**Category:** Developers Forum\
**Created:** [September 30, 2013, 5:18pm UTC](https://www.dynamicsuser.net/t/problem-in-sum-calculating-inside-2013-report/48498 "2013-09-30T17:18:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![poppins](https://avatars.discourse-cdn.com/v4/letter/p/df705f/32.png) [@poppins](https://www.dynamicsuser.net/u/poppins)\
**Post date:** [September 30, 2013, 5:18pm UTC](https://www.dynamicsuser.net/t/problem-in-sum-calculating-inside-2013-report/48498/1 "2013-09-30T17:18:58Z")

</div>

Hi everyone,

I have a report to upgrade from nav 2009 to NAV 2013.  
The report consists of two data items: Date(parent) and GL/Entry.  
The following code was in the OnPreSection of a group footer related to GL/Entry dataitem in the Classic report (grouped by GL Account No.):

`IF (("Debit Amount" - "Credit Amount") > 0) THEN`  
`DebitG2 := DebitG2 + ("Debit Amount" - "Credit Amount")`

`ELSE`  
`CreditG2:= CreditG2 + ("Debit Amount" - "Credit Amount");`

`END;`

I inserted the same code in the OnAfterGetRecord trigger of the GL/Entry dataitem in my 2013 report …but it isn’t behaving as expected (like in 2009)…It is just returning the sum of “Debit Amount” in DebitG2 and the sum of “Credit Amount” in Credit G2.

I don’t understand why is that…  
What shall I do?

---

<div class="post-metadata">

**Author:** ![MarshalJ123](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@MarshalJ123](https://www.dynamicsuser.net/u/MarshalJ123)\
**Post date:** [October 1, 2013, 10:01am UTC](https://www.dynamicsuser.net/t/problem-in-sum-calculating-inside-2013-report/48498/2 "2013-10-01T10:01:08Z")

</div>

Hi

I guess you want to show Group Total of credit and debit difference, As per your code you are trying to create running total of two variables at OnPreSection() (In NAV2009) and clearing those variable at OnPreSection() of Group Header. But in 2013 we do not have section triggers so we cannot clear those variables when new group begins. so you have to handle this in visual studio side.Design your report and write a expression to find difference and sum the difference

**To Find Difference**

=iif((Fields!DrAmt.Value - Fields!CrAmt.Value) \> 0,(Fields!DrAmt.Value-Fields!CrAmt.Value),"")

**To Sum The Difference**

=sum(iif((Fields!DrAmt.Value - Fields!CrAmt.Value) \> 0,(Fields!DrAmt.Value-Fields!CrAmt.Value),""))

i have created a simple report to achieve this please have a look at it

---

<div class="post-metadata">

**Author:** ![MarshalJ123](https://avatars.discourse-cdn.com/v4/letter/m/b3f665/32.png) [@MarshalJ123](https://www.dynamicsuser.net/u/MarshalJ123)\
**Post date:** [October 3, 2013, 7:08am UTC](https://www.dynamicsuser.net/t/problem-in-sum-calculating-inside-2013-report/48498/3 "2013-10-03T07:08:54Z")

</div>

[8765.CrDrDiffSum.bmp](https://www.dynamicsuser.net/uploads/short-url/5bx5GneQ4zMPZwwCWcQD5frWDUA.bmp) (1.05 MB)