Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summing outside of group

Status
Not open for further replies.

sabobas

Technical User
Jul 28, 2005
2
US
This may be difficult to explain as I do not use Crystal often.

Brief description of the desired report:
A customer with different locations(custid's) is given aggregated prices based on the combined product order quantities of each product. Our billing system is not capable of doing this calculation. I have been able to create the pricing formulas for various qty thresholds and using running totals in the groups I can calculate the correct price IF I group by product.

I would like to create a less detailed report that is not grouped on product, but still has the correct updated prices. If I change the grouping to anything other than product, my running totals look up the prices on all products, not each particular product.

Example desired report:
Custid, ProductId,Qty,Recalculated Price,RecalculatedCharge

Any advise for getting started would be helpful.




Pricing Formula:
IF {monthlysummary.productid} = "STD WIDGET"
THEN
IF Sum ({monthlysummary.eventcount},{monthlysummary.productid})>5000 THEN .30 ELSE
IF Sum ({monthlysummary.eventcount},{monthlysummary.productid})> 1000 THEN .36 ELSE .50
ELSE
IF {monthlysummary.productid} = "MINI WIDGET"
THEN
IF Sum ({monthlysummary.eventcount},{monthlysummary.productid})>5000 THEN .20 ELSE
IF Sum ({monthlysummary.eventcount},{monthlysummary.productid})> 1000 THEN .26 ELSE .40

Etc.
 
I don't know how to edit my post, but I am using Crystal 6.0
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top