Hi

I am quite new to CR and would like some advise on the below or if possible a workaround.

I have a sap query which returns a finished product and the raw material components which make up that product. As there are x number of components to one product the finished product line is duplicated on each row of the raw material line.

I need to calculate the finished product selling price less the total of raw material components. I can do this as per the below.

Group By PO No

FinshProd SoldPrice RawMat CostPirce
Prod A    20        Raw A 1
Prod A    20        Raw B 1
Prod A    20        Raw C 1
Prod A    20        Raw D 1
Prod A    20        Raw E 1

Group PO Sum
Average Sold Price 20 Cost Price 5 Profit 15

The issue I have is that I want to sum total for every finished product in the report. e.g the average sold price in the grouping.

Many Thanks !!!

Chris :-)

Edited by chrisfaw - 05 May 2016 at 7:38am

Hi,
I reckon you have it grouped by finished product?
You could create a formula saying
average({table1.finished_product},{table1.finished_product}) - sum({table2.raw_product},{table1.finished_product})