help for report

  • Thread starter Thread starter jj
  • Start date Start date
J

jj

Hi

I have a report which I must Look like the following:
Country 1:
Factory 1:
Date 1 Date2 Date3 Date4 Date5
Income: 100$ .... ......
expences: -40$
tax: -25%
Sum: 45 $

Country 1
Factory 2:
Date 1 Date2 Date3 Date4 Date5
Income:
expences:
tax:
Sum:

etc.
My Query looks like the report -execpt from the sum row - But I have been
wundering for hours how to find the Sum - The reports should be grouped by
Country and Factories.

Help is really appreciated.

TIA
/JJ
 
Use Grouping and Sorting with group header and footer. Do the math for the
sum in the group footer.
=(([Income] + [expences]) * [tax]) + ([Income] + [expences])

Based on what kind of field [tax] is you may need to to more math and
functions.
 
Back
Top