Jump to content

TOTAL OF INDEX FIELDS


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

Recommended Posts

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.

Link to comment
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

Link to comment
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

Link to comment
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).]

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.