Need to get a total of taxes

[jwnacnud]

Filemaker 7

Windows XP AND OSX 10.4

I have a table named [OrderCharges]. In this table are the following fields:

ChargeID: Unique ID

OrderID: Foreign Unique ID

Type: Text field

Amount: Number field

In the Type field, there can only be Tax or Shipping.

I need to calculate the total amount of Tax and also the total amount of shipping based on the current found set.

Would this be a calculaton or part of a report that I would solve this?

Thank you in advance

[jamesducker]

There are many ways you could do it. One of the most popular would be:

1) create a summary field which gets TOTAL of AMOUNT

2) create a new 'part' on your layout which is sub-summary when sorted by TYPE

3) put the TYPE field, and your new summary field, in to this part

4) sort records by TYPE

5) go in to PREVIEW MODE; the part will appear with the totals in for each type

As I say there are several other ways of getting a total, it depends what you need it for. But I hope that helps as a starting point.

James

[Brent Durland]

To view a total in a simple list view, without going to preview mode, I would create a calc field that shows the amount only if it is the "tax" type, then create a summary field that totals the new calc field. You can place the summary field in the body, header or footer.