Print Page | Close Window

Percentages on monthly management reports 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=12176 Printed Date: 03 May 2024 at 8:22am Topic: Percentages on monthly management reports Posted By: ferrarirules83 Subject: Percentages on monthly management reports Date Posted: 27 Jan 2011 at 5:46am Hi everyone I am a CR newbie so bear with me if any of queries are very basic! I have attached an image of the report: http://img683.imageshack.us/i/mgtaccountspdf.jpg/ I need to add a couple of percentages and I am not sure how I could achieve this. I need to show Gross profit and Gross profit after other income as %ages of Total Sales. The reason I am stuck is the report is grouped by major heading ie sales, direct costs, overheads etc. So I cannot do a simple formula like Gross profit / Sales *100 because they appear in different groups. I have calculated Total sales as total of all transactions with major heading as "sales". So when I come to gross profit level the major heading changes to "direct costs". So I am not able to do a simple percentage because I can't think of what the denominator should be! Any guidance would be most appreciated!

Print Page | Close Window