April 6, 200124 yr Newbies 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.
April 6, 200124 yr The Sum() function will add up all the repeats of a repeating field. Total = Sum(RepeatingField) -bd
April 6, 200124 yr Author Newbies 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 ]
April 7, 200124 yr 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
April 10, 200124 yr Author Newbies -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
Create an account or sign in to comment