Ask Your Question
1

how to generate subtotals in a report?

asked 2014-09-15 17:28:42 +0200

Using Report Assistant in Base. Sorting/Grouping for Column Cost. No Subtotals and Total for Column Amount. How to make these Totals?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2015-02-23 00:02:53 +0200

nettings gravatar image

updated 2015-02-23 00:03:51 +0200

Add a textbox with Data Field Type "Function", choose the appropriate field from your table or query, and set Function to "Accumulate". Set the Range as required. You will find a field name like [AccumulationYourfieldYourrange], which I found can also be typed into formulas. So in order to add German VAT, you could say "=[AccumulationYourfieldYourrange]*1.19".

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2014-09-15 17:28:42 +0200

Seen: 623 times

Last updated: Feb 23 '15