hapivo

Sum of repeated fields

Discussion created by hapivo on Feb 7, 2017
Latest reply on Feb 11, 2017 by philmodjunk

Hi there.

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.

 

ComponentPricecontent in mixture (%)Calc
barley 1033330
wheat1533495
corn2034680
100%15,05

many thanks for your help Ivo

Outcomes