gaby78 Posted September 21, 2006 Share Posted September 21, 2006 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 Link to comment Share on other sites More sharing options...
comment Posted September 21, 2006 Share Posted September 21, 2006 Theoretically, no. Practically, yes. Link to comment Share on other sites More sharing options...
gaby78 Posted September 21, 2006 Author Share Posted September 21, 2006 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. Link to comment Share on other sites More sharing options...
comment Posted September 21, 2006 Share Posted September 21, 2006 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6561 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now