Can not sum all fields... HELP...

[eric2k]

I am new to filemaker 6 and scripting for that matter. This has to be an easy problem to fix (I am so defeated that I haven't figured this out!)

Problem: After importing from MS Excel my book of Annuity customers. I have a number field named "Invested" -> I want create a field that will take all of these sale amounts (about 625 of them) and add them up in a running total field to track all of my sales.

I tried to created a calculation field called "Total Sales" and did this:

Sum(Invested)

This obviously doesn't work - any suggestions...

eric2k

[PrincessJo]

I'm using FileMaker 5, so I'm not sure if it's different.

Make the total field a summary field, rather then a calculation. You can then select the field you want it to add up, and there's a check box for a running total or not.

Hope this works.

Jo

[spb]

Making a summary field would work, perhaps. I would place this field in the header of a layout, rather than body. A problem I've encountered is that the summary field will only summarize the fields in a current found set. If you need a running total of all records, then to view you'd need to show all records. If you are working with a small found set, the field will be useless.

What are the differences between using a defined summary fild, and a calculation field defined with a Sum calc?

Steve Brown

[eric2k]

This is the problem that I am having... The sum calc only works for the current record... I need a static running total...?

Is there an "include all records" type of function that I can use? And then apply the sum function to that total?

[Ugo DI LUCA]

Assuming you have a calculation for each record called "Invested" which is Sum(Invested), make a selfrelationship and a calculation SUM(CurrentFiletoCurrentFile:sale using this relationship :

CurrentFile::Invested::CurrentFile::Invested