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.
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.