I am querying an external database to retrun a pivot table, then i am adding
a calculated field that calculates Regular hours * Bill rate. to come up
with total revenue. When it runs, the calculated amounts are 2, 3, 4 times
more that what it should be.

any ideas how i can get this calculation to return the right amounts.

thanks
Jerry