Jump to content

SumOfProducts


This topic is 6461 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 6461 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.