I have a number field with 20 repetitions. I need to have a display field for all repetitions that is based on a billing flag of "1". In my display calc I'm using is this:

case(billing flag = 1, billed hours)

It works for the first repetition but not the other 19. Any thoughts???

Use the Extend() function when referring to non-repeating fields in a repeating calculation field.

Yes!! I just figured that out by reading another post. It works beautifully.

Man, I hate repeating fields...I hardly ever use them but in this instance it was the best choice. Imagine that.

Thanks again.

I hate repeating fields.

Why? What have they ever done to you?

http://fmforums.com/forum/showtopic.php?tid/190245/

"The child who recieves a hammer for christmas will discover that everything needs pounding"

No matter in what order each of the tools comes to you intellectually, will you abuse them until you wommit!

--sd