dbTalk Databases Forums  

calculation fields not calculating

comp.databases.filemaker comp.databases.filemaker


Discuss calculation fields not calculating in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
stabit
 
Posts: n/a

Default Re: calculation fields not calculating - 04-01-2007 , 04:37 PM






On Apr 1, 3:58 pm, "Ursus" <ursus.k... (AT) wanadoo (DOT) nl> wrote:
Quote:
Hi again. I am not trying to count across records. I am actually
trying to count within one record. Each fish collection is a record.
I may have 100 fish in one record. Unfortunately, I have not figured
out how to total columns in a portal within a record. I want to know,
withing one record, how many of my fish I caught are bottom feeders.
With that total number, I can calculate "benthic fluvial specialists".
Any help would be great! Is this even possible within one record?
STabit

Perhaps in this case a repeating field can help. Normally I would advise
against yusing them, but in this case it might just do what you need.
Create a number field many repetitions as you need. MyField
Number;repeating
Create a calculation cMyTotal <number ; Sum ( MyField )

when you have filled all the repetitions you need you see the total of all
the fish in the cMyTotal field

Hpe this helps

Keep well, Ursus
REPEATING FIELDS WORKED!!!!!!



Reply With Quote
  #12  
Old   
stabit
 
Posts: n/a

Default Re: calculation fields not calculating - 04-02-2007 , 07:31 AM






On Apr 1, 5:37 pm, "stabit" <sharon.ta... (AT) gmail (DOT) com> wrote:
Quote:
On Apr 1, 3:58 pm, "Ursus" <ursus.k... (AT) wanadoo (DOT) nl> wrote:



Hi again. I am not trying to count across records. I am actually
trying to count within one record. Each fish collection is a record.
I may have 100 fish in one record. Unfortunately, I have not figured
out how to total columns in a portal within a record. I want to know,
withing one record, how many of my fish I caught are bottom feeders.
With that total number, I can calculate "benthic fluvial specialists".
Any help would be great! Is this even possible within one record?
STabit

Perhaps in this case a repeating field can help. Normally I would advise
against yusing them, but in this case it might just do what you need.
Create a number field many repetitions as you need. MyField
Number;repeating
Create a calculation cMyTotal <number ; Sum ( MyField )

when you have filled all the repetitions you need you see the total of all
the fish in the cMyTotal field

Hpe this helps

Keep well, Ursus

REPEATING FIELDS WORKED!!!!!!
Unfortunately, I have a new problem. I have some fields in a layout
that are all located on the same table. Originally I could type in a
genus species and automatically the family and common name would be
populated (all in the same layout).
I need one of the "auto populating" fields to auto populate in another
layout that belongs to a different table. Everytime I try to create a
new record in the second layout, and wait for that one field to
populate with info I KNOW is in there from the other layout, it just
remains blank. It is driving me crazy!
Do I need a portal, or can I use a repeating field? Once the info
starts showing up, I will need to total it just like I did the other
repeating fields we discussed.



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.