Calculation Question

[canon29]

In version 8, how do we create a new file that collects the totals of certain specified fields?

Thanks!!!!

[mr_vodka]

Hi and Welcome to the Forums.

I think that the question you are asking is a little too vague. What do you mean by "collect the totals".

Are they text fields, number fields, etc. ?

Are the fields in one table or related?

Why do you need a new file?

Please give us more details of what exactly you are trying to do so that we can help you.

[canon29]

Sorry, I'll try to define the problem a little better.

We have a file for our 2006 invoices and accounts payable and we need to extract info like the total spent on gas, office supplies, etc., which are already defined in the file. Other than exporting to Excel, is there a way we can add up certain fields in FileMaker?

Thanks!!!

Edited January 11, 2007 by Guest

[mr_vodka]

You still have not given us enough details. Is there more than one table? If so, how are they related? Do you want to add up certain fields on a per record basis? or get a final summary in the whole table of all these items. Its still a little unclear to as what you exactly are looking for but maybe this will help.

For example, if you just wanted to add up the cost of certain fields in one particular record and they are within that record, then you can just use a simple calculation field of:

gas + office + food + etc

But if this is setup relationally, then in the Accounts payable table, there should only be one field for a Cost rather than multiple with another field called category or something that categorizes what it is.

[canon29]

I wish it was that easy. Can I send you a sample file somehow? I have the MAC version.

Thanks!