I am trying to customize a trial balance report in nav 2015 so I bring overall total at the end of the report on both credit and debit for Net change and balance headings.
Does anyone have a way to make that happen cos when I try it does not display what a I want.
Do you want your total below Debit total, Credit Total etc.
Put a text box below those textbox
in the expression just summarise by Sum.
I think it must help you if not please reply.
I tried the Sum on the report builder but it did not sum up the columns for me.
Its working now. I used the create totals feature to create a new row on which I placed the fields.