Issue in totaling

Business Central/NAV User Forum
1

Hi,

I am preparing a report using 2 tables “Sales Invoice Header” and “Sales Header”. These two tables have no link with each other as the values they show are not related to each other. The footer of “Sales Invoice Header” shows the total of few fields which are variables, for ex “DiscountAmt” . As the same the footer of the “Sales Header” also shows the total of few fields which are variables, for ex “DisAmount”. The issue is, I want the total of these 2 variables DiscountAmt and DisAmount as grandtotal. How do I do this? In which tables’s footer should I show the grandtotal? I tried it in Sales Header’s footer, buy creating a new variable n summing

SumTotal := DiscountAmt + DisAmount;

But with this its showing only the DisAmount value. Can anyone help me with this.

Thanks…

2

You should sum them in Individual Group footers…

3

Thanks for the reply…

First the variables are summed up at footer of respective tables and then for the grandtotal your asking to use the groupfooter is it?? Groupfooter of which table?