Newbie Questions

Re: using the sum function in a repeating form

r-squared — Thu, 04 Nov 2010 22:40:06 GMT

Jimmie -- thanks so much.

I hate it when I am a "complete" idiot. Nice catch!

Re: using the sum function in a repeating form

Jimmy — Thu, 04 Nov 2010 20:47:31 GMT

The problem is that you have two different modhours fields in your data source (modhours and ModHours), and your sum() function is referring to the one that's not actually being used in the form.

Re: using the sum function in a repeating form

r-squared — Thu, 04 Nov 2010 20:19:21 GMT

Ok, i found the attach file in options tab. Here it is.

Re: using the sum function in a repeating form

r-squared — Thu, 04 Nov 2010 20:04:48 GMT

Sure. However, I must be brain dead this pm as I don't see an icon to attach a file in the forum writing tool. <sigh>

Re: using the sum function in a repeating form

Jimmy — Thu, 04 Nov 2010 19:13:39 GMT

Might you be willing to attach your form to this forum thread? This should work pretty easily, so it's hard to guess what's wrong without a very detailed description of your form's setup.

Re: using the sum function in a repeating form

r-squared — Thu, 04 Nov 2010 18:22:49 GMT

No, the update this value check box is checked; I have, however, tried it both ways and still get a zero in the sum box.

Re: using the sum function in a repeating form

Jimmy — Thu, 04 Nov 2010 17:52:04 GMT

Do you have the "Recalculate this formula when the value changes" box unchecked in tothours' properties?

using the sum function in a repeating form

r-squared — Thu, 04 Nov 2010 17:34:23 GMT

Hello -- I am a newbie. I am NOT a programmer and really don't want to be a programmer -- but I need to get a relatively simple form produced.

This form will help the end user produce a course outline and at the same time give the manager of the team (myself) an estimate of the hours required to develop the course.

The form consists of a repeating form with five or six questions about the specific module in a course. At the end of the form there is a section for the instructional designer to fill in the amount of time in hours that he or she believes it will take for them to complete development of a specific module.

If they need more than one module they repeat this form and go through the process again.

At the end of the form there is a place for the sum of the hours to come up.

First mistake had something to do with the control form doing duplicate date -- and so when you pressed the repeat button and filled in the hours whatever went into the last post would get put in all hour boxes.

Somehow I fixed that. So now that control is a simple text with double decimal as the data type.

However, now the total hours control only shows a zero (0), The set-up is as follows:

The control in the repeating form (where users are outlining each module) is named modhours and is set for a datatype as double decimal.

The control at the end of the repeating form is named tothours. It is set as a double decimal as well.The value for this control is sum(modhours),

Any ideas on how to resolve this would be greatly appreciated.