I have 3 repeated fields Component, price and content in%. I would like calculate the price of the mixture. So I have created another repeated field Calc (=Price*content in mixture) and the field Price (=Sum ( Calc)/100). But it is too complicated. Is there any possibility to specify calculation of the price directly in the field Price without creating and using repeated field Calc.
|Component||Price||content in mixture (%)||Calc|
many thanks for your help Ivo