Calculation using sub summary fields
Here's my (simplified) problem:
I have a report that creates a sub summary of sales_cost and sales_price for each customer when sorted by customer_name. What I need are two more fields on each sub summary row that provide sales_profit (sales_price - sales_cost) and the sales_profit_percent (sales_price - sales_cost / sales_cost * 100).
Thanks for any solutions.