Simplest to understand is to use a script. (This can also be done with a recursive custom function if you have FileMaker Advanced )
Set Variable [$K ; Value: $K + 1 ]
Exit Loop If [ $K > ValueCount ( yourTable::Field A ) ]
Set Variable [ $AddList ; value: List ( $AddList ; GetValue ( YourTable::Field A ; $K ) + YourTable::Field B ) ]
Set field [Yourtable::Field C ; $AddList ]
I do have advance, how would this be done using "recursive custom function"
// AddToListItems ( TheList ; Addend )
// TheList : A return separated list of values
// Addend : The value to be added to each item in the list
Case ( ValueCount ( TheList ) = 0 ; "" ;
let ( [ FirstItem = GetValue ( TheList ; 1 ) ;
ListRemainder = RightValues ( TheList ; valueCount ( TheList ) - 1 )
List ( FirstItem + Addend ; AddTolistItems ( ListRemainder ; Addend ) )
) // let
) // case
Ok now im not quite sure on how I use this. I thought File>Mange>Custom Functions but this is a first for me.
Yes, go to file | Manage | custom functions.
Click new. You can paste all the text in my last post directly into the New Function box but then you'll need too further copy and paset AddToListItems into the Function name box. Then you must also separately copy and paste TheList and Addend parameters into the Function Parameters box, clicking the + button after pasting each parameter name.
Then you can Click Ok and when you next specify a calculation, you'll find AddToListItems listed with the other functions you can use to construct a calculation.