# TOTAL OF INDEX FIELDS

This topic is 8465 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I HAVE A FIELD THAT IS HAS REPATITIONS SET TO INDEX 7 TIMES. I NEED TO TOTAL UP ALL THE NUMBERS FROM ALL SEVEN REPATITIONS IN A SEPARATE FIELD. DOES ANYONE KNOW HOW THIS CAN BE DONE?

##### Share on other sites

Assuming you mean you have a repeating field and want the total for the first seven repetitions, create a calc field that adds them up -- using the "Get Repetition" function.

HTH,

Dan

P.S. In general, using all caps on the web is considered shouting; please refrain from doing so unless you mean to shout.

##### Share on other sites

Sorry about the shouting. I could sure use more help. Lets say I have a repeating field named "Number" , That repeats 7 times. How would the calc read for the " "Total number" field. I noticed that the "GetRepetition" option contains (repeating

##### Share on other sites

Ok Lets act like I'm really stupid! How would this calc look when define the "total" field.

I only have two fields.

" Number" this field has a repatition of 7.

and "Total Number" This will give a total of all the numbers in the 7 number fields.

Please don't get the wrong idea, I'm greatful for your help, but I'm also not advanced user.

Thanks,

RET

##### Share on other sites

The calculation is just:

Sum(Number)

When you define the Total Number field, you select the "Calculation" option. Then you into the field options dialog. Enter the above formula as the calculation formula. Select "number" as the calculation result type from the popup menu at the bottom of the dialog box. That's it.

[This message has been edited by BobWeaver (edited March 20, 2001).]

##### Share on other sites

Define a field:

TotalOfRepeats (calc, number) =

Sum(Repeating Field)

-bd

Thanks

##### Share on other sites

This topic is 8465 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

• ### Similar Content

• #### Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 4,463 views
• #### FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 5,251 views
• #### Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 3,483 views
• #### Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with:

• 3,101 views
• #### Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

• 2 replies
• 2,730 views
×
×
• Create New...