Calculating Stats within the same Record
Posted on 2011-03-17
I have a query that I am building for a complex report. The headings are:
* Sales Dollars
* Sales Units
* Avg Inv $
* Margin Dollars
* Margin %
* Turn Rates
For Sales Dollars, Sales Units, and Avg Inv $, I am just summing the records in the aggregate query. The Margin Dollars is ([Sales Dollars] - ([Turn Rate] * [Avg Inv $]))/52.
The problem is with calculating Margin % which is: [Margin Dollars] / [Sales Dollars]. When I run that expression, it errors out with an Overflow Error.
What is the best way to calculate data like this?