How to use repeating field in calculation

[BigMike]

I have a repeating field defined where the user can enter the number of hours worked. I need to take than entry and multiply it by a separate field that contains a standard hourly rate (non-repeating) to arrive at a total dollar figure. The first repeating field entry works, but none of the others do.

[comment]

Use the Extend() function to reference a non-repeating field in a repeating calculation field.

Of course, you could just get the result directly in a non-repeating calculation =

Sum ( Hours ) * Rate

[Søren Dyhr]

Strictly speaking can't users enter anything in repeating field, if you keep your self on the straight and narrow - watch the BTW in this post!

http://fmforums.com/forum/showpost.php?post/302551/

Reserve repeating fields for utility purposes only, as rule of thumb could they only be shown on any layout as a calc'field ... and then try to let anyone enter anything in them

The straight and narrow, is here 1NF!

--sd