SumOfProducts

[gaby78]

Assume the following situation: a Quantity field and a Price field in a child table. I just need the sum of the all the Qty*Price on the parent layout; I don't need to see the individual results (product per row). I can create a 3rd field in child table LineTotal = Qty*Price and a new calc field in the parent to sum LineTotal = Sum (LineTotal).

I tried the formula = Sum(qty*Price) but did not work.

I am just wondering if this is the only way to get the sum of (Qty*Price) from a child table.

Thanks

[comment]

Theoretically, no. Practically, yes.

[gaby78]

Hi comment:

If the solution is not too complicated I would love to hear about it. I have a situation where a price has 5 components (added together to give the price per unit) and a qty field. With a solution, I won't have to create 5 new (component*qty) fields.

Thanks in advance.

[comment]

I'm afraid you have lost me somewhere: I thought you had a child table where each component is a record with Price and Qty. In any case, the alternative would require a custom function and is too complex to be practical.