dbTalk Databases Forums  

Calculations In Filemaker Pro

comp.databases.filemaker comp.databases.filemaker


Discuss Calculations In Filemaker Pro in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Grammie
 
Posts: n/a

Default Calculations In Filemaker Pro - 07-29-2005 , 05:14 PM






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


Reply With Quote
  #2  
Old   
Bill
 
Posts: n/a

Default Re: Calculations In Filemaker Pro - 07-29-2005 , 05:29 PM






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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.