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.
Thanks, that at least shows calculations can return repeating values.
Here's my calculation, defined to return a numeric result with 10 repetitions,Let([$iar = Alpacas::IAR;$query = "SELECT ancestor_IARFROM Ancestor_stepsWHERE IAR = ? and mismatch_on_inbreeding_precentage = ?";$result = ExecuteSQL ( $query; ""; ¶; $iar; "Yes")];$result)I can't force $result to be treated as something that has repetitions. I thought using Char(29) instead of ¶ would do the trick, but alas no.