### Title

Calculated field that repeats, how is it done ?

### Post

I have a calculation field that has 10 repetitions.

The calculation so far has produced a variable $result that contains a series of numbers, each separated by ","

If the calculation returns $result as it stands, the first repetition of the field takes the entire string.

How do I return $result so that it fills each of the field's repetitions with one of the values ?

I've tried replacing "," with Char(29) - the Group Separator, but that doesn't seem to work.

thanks,

rob.

There is a caveat for a single number field when used in a calculation with repetitions, using EXTEND with the non-repetition field. I was not able to duplicate a problem. I have not worked with REPEATING fields for a long time, using related fields instead.

I created three repeating fields, QTY, PRICE, and EXT. I created a non-Repeating SUM field to sum the extend amounts. Both QTY and PRICE are number with 5 repetitions. EXT is a calculated field QTY * PRICE. Sum is a calculated field that is SUM(EXT).

All worked as I would hope.