Sum of Repetitions Fields

[mPhillipps]

What is the correct specify calculation to achived the sum of each entery in a repetition fields?

I have a pop-up menu field (time hrs.) with repetition X8.

And a calculation field (total time) to add each repetition field entery together.

I am not able to define a calculation that will add each entery together and display.

[LiveOak]

The Sum() function will add up all the repeats of a repeating field.

Total = Sum(RepeatingField)

-bd

[mPhillipps]

Thank you for your rapid response.

I tried this furmula "Total Hrs =sum(Time Hrs)" and got this error message;

This field can not be used becaure it would cause a circular difinition.

What are your thoughts?

Thank you,

Mark

[ April 06, 2001: Message edited by: MPhillipps ]

[LiveOak]

Are you sure you didn't enter:

Time Hrs = Sum(Time Hrs)

instead of

Total Hours = Sum (Time Hours)?

A circular definition is using a field to define itself. Or is Time Hrs a calculation based upon Total Hrs?

-bd

[mPhillipps]

-bd

I know this should be a very simple calculation...but:

When I use the formula:

Total Hours = Sum (Time Hours)

I get the error message, so for laughs I used:

Time Hours = Sum (Time Hours).

And the formula was excepted a valved Calculation.

So I deleted both fields and started over and got the same error message.

Thank you,

Mark