simple sum problem

[tcomet]

trying to sum a bunch of repeating entries of the same field. should be simple but I can't get it to work...

[mr_vodka]

Sum ( YourRepeatingField ) should work.

[tcomet]

I think it is just a syntax thing. This is what I have been trying:

Sum ( RepeatingHours Logged)

my field is named Hours Logged

How would I write that?

Thanks

[mr_vodka]

Its should just be Sum ( Hours Logged) if the field Hours Logged is a repeating field.

[Lee Smith]

Is anything showing in the field, such as a question mark, or is it blank?

Is there a second TO involved?

Can you attach a sample of your file?

Lee

[mr_vodka]

BTW perhaps you should discuss why you are using repeating fields. It is not usually recommended for true data.

[tcomet]

The first thing I tried was sum (Hours Logged) but it just gave me the hours for the entry I was on. Basically this is a log style database with two layout formats. One is descriptive where there are many aspects of a job listed for each job (page). Each page has many entries and represents one job. This generates a second layout that is a simple resume that lists the basics of all the jobs on one page. It is here that I want to display the sum of the total hours for the 'hours logged' from each job. Perhaps I am doing it all wrong. Probably...

[comment]

It is not clear what you mean by "many entries". Does a job have many fields for this, or is it one repeating field, or do you just have multiple entries in a single field (separated by what?).

BTW, neither one is a good way to approach this. You should have a table for Jobs and a related table for logging hours, where each log entry is a separate record.

[tcomet]

This is my file:

http://www.circusorange.com/Rigging_Journal.fp7

[comment]

Change Total Hours into a Summary field (Total of Hours Logged). You need to change Hours Logged into a Number field for this.

[tcomet]

That's it. 'summery field' worked perfectly. Thanks!