Sum of an Expression?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data base with items sold per location. I have an expression where
I calculate the net sales and cost of goods sold.

I want to subtotal by location and calculate the overall cost of goods sold
by location, not by item.

Basically I want to sum the net sales and cost of goods sold expressions.

Can I do this? Bring on the suggestions!

Thanks,

Marc
 
You can set the sorting and grouping by location and then other fields. Show
the location group footer and use this section for totals.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up row values 4
Two tables, multiple relationships? 1
How to ignore a column of numbers in Grand Total for rows 1
Sum a count total 2
Pulling data out and understanding total queries 3
Sum Expression gives 1.45519152283669E-11 instead of 0 (zero) 6
Calculating a grand total for an unbound control in a report 9
duplicate query 1

Back
Top