Sum an Average Filed
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21955
Printed Date: 05 May 2024 at 12:06pm
Topic: Sum an Average Filed
Posted By: chrisfaw
Subject: Sum an Average Filed
Date Posted: 05 May 2016 at 7:35am
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 :-)
|
Replies:
Posted By: chrisfaw
Date Posted: 09 May 2016 at 1:47am
Any news on this? Or is this not possible?
Regards
|
Posted By: Gurbs
Date Posted: 09 May 2016 at 3:13am
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})
|
|