Total Sum of Column Fields by Group

Epicor ERP 10
,
1

Hi Experts,

I am trying to create a BAQ that will display total price sold on specific product group.
In a standard BAQ format, it shows all occurrences of a product group thereby creating hundreds of lines.

Is there anyway I get the total price by product group to show on the BAQ without doing sum?
Please see attached for reference.

image
image1497Ă—667 38 KB

Thanks
Chemuel

2

Try to use Group by and Calculate field with Sum Aggregate function.

3

Hello, I tried this and it works fine with standard fields. Thank you.

On this specific case, I would like to get the sum of the calculated fields but they aren’t stored in any table I assume.

4

you could calculate the value for each line and sum that…

Sum (OrderRel.OurQty * OrderDtl.UnitPrice) for example…

5

Just use Sum(CalculatedFieldName) and replace that with whatever your field name is.

Dragos

6

Thanks Gentlemen for the replies.
Working as intended now.