Sales Calculation Issue
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23035
Printed Date: 14 May 2024 at 6:18am
Topic: Sales Calculation Issue
Posted By: bjfils
Subject: Sales Calculation Issue
Date Posted: 20 Apr 2023 at 5:36am
I have a report where I'm trying to calculate the sales dollars per square inches of the item sold. For most orders, the sales dollars are easy, ShipQuantity*PricePerM. However, we have one customer where price is not specified per item, but for the order in total as MiscCharge. If they only order one item, it's still easy at ShipQuantity*MiscCharge.
However, if they order multiple items, that won't work as the MiscCharge could be for 3 different items where they order 3000 of one item, 2000 of another, and 1200 of a third. There's nowhere in the data that 6200 units exists as a number. Each item appears as a separate line item.
I think I need to be able to sum the ShipQuantity by order number, but can't figure out a way to do that and still get the rest of the report to work. Help!
|
Replies:
Posted By: bjfils
Date Posted: 20 Apr 2023 at 9:14am
|
I found a field in one of the tables that I didn't know existed, so I was able to get it working!
|
|