How to use PowerPivot to perform division of two columns?

[docardlove1980]

I'm using excel PowerPivot to do some reporting. I have 2 business columns: FTE and Revenue. When doing =SUM([Revenue]) / SUM([FTE]) to calculute Revenue per FTE, PowerPivot spits out an incorrect answer (I know it is incorrect because if I perform the sums separately on another table and THEN divide the two, the answer is different). Does anyone have any idea how I might solve this problem?

Arbitrary example: FTE contains 0.2 and 0.1. Revenue is $5000 and $50000. The answer for "Revenue Per FTE" should be $18,333.3, which is ($5000 + $50000) / (0.2 + 0.1).

Please keep in mind this is PowerPivot, not normal excel. I can make the forumla work in a normal excel environment.
Gaming Graphic Designing Companies in Bangalore

 

[mdrew9]

I'm using excel PowerPivot to do some reporting. I have 2 business columns: FTE and Revenue. When doing =SUM([Revenue]) / SUM([FTE]) to calculute Revenue per FTE, PowerPivot spits out an incorrect answer (I know it is incorrect because if I perform the sums separately on another table and THEN divide the two, the answer is different). Does anyone have any idea how I might solve this problem?

Arbitrary example: FTE contains 0.2 and 0.1. Revenue is $5000 and $50000. The answer for "Revenue Per FTE" should be $18,333.3, which is ($5000 + $50000) / (0.2 + 0.1).

Please keep in mind this is PowerPivot, not normal excel. I can make the forumla work in a normal excel environment.
Gaming Graphic Designing Companies in Bangalore

How are you calculating FTE? Are you getting your hours from the date table or inputting FTE amounts directly?