September 7, 200817 yr 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.
September 7, 200817 yr 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
September 7, 200817 yr 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
Create an account or sign in to comment