Calculation in repeating fields

[chemlady]

Hi! I'm new here and hope you'll forgive me if my question is too easy.

I have "Yield" field and 2 repeating fields "wt%" and "Amount in LBS". In "Amount in LBS" field I need the following calculation performed: (Yield * wt %) / 100.The problem is that when I change the value in the "Yield" field, just the first row in the repeating field recalculates itself. What do I need to do to make all the rows in the repeating field recalculate?

Thank you!

[transpower]

Easy. Let ( [ R = Get ( CalculationRepetitionNumber ) ] ;

Extend(Yield) * wt%[R]

)

[chemlady]

Thanks! Works!

[-Queue-]

Note that there's no benefit in using Let here as opposed to

Extend(Yield) * wt%[Get(CalculationRepetitionNumber)]