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.