AnsweredAssumed Answered

Multiplying then summing multiple fields in a calculation

Question asked by ohook on Dec 6, 2017
Latest reply on Dec 6, 2017 by keywords



I'm trying to create a calculation for the cost of an assembly in a bill of materials.  I need to take the price field of items listed in a bill of materials table and multiply them with a quantity field and then sum all of the results. The bill of materials can have anywhere from 1 to 1000 items in it, which would need to be multiplied by quantity, then summed to give a total cost of an assembly. Is it possible to do this within a single calculation? Or would I need to create a custom function? I'm fairly new to Filemaker Pro, so any guidance would be greatly welcomed.