In article <1122675245.653641.325110 (AT) o13g2000cwo (DOT) googlegroups.com>,
"Grammie" <bmoos1 (AT) yahoo (DOT) com> wrote:
Quote:
I have fields "message", "spoke to" and "email". Each week I have to
add up the figures in those fields by hand. How can I have that
calculated at the bottom of the form that's been created?
Any help would be appreciated. I'm a newbie to Filemaker. Just
started changing the form since I've gotten this job. Trying to make
it be helpful.
Thanks,
Grammie |
To add up numbers, then numbers need to be in number fields. Then you
can create summary fields that sum them up, or create a
self-relationship and use the sum function in another calculation field.
To count occurrences of fields that have data in them, you can use Count
summaries or the Count function.
If you have text fields that also happen to have numbers in them, you
probably can not perform calculations upon those numbers, at least not
in any straightforward way. You need to have the numbers in number
fields.
Bill
--
For email, remove invalid.