cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aktec4 Frequent Visitor
Frequent Visitor

Percentage of Revenue

hello,

 

I need your help to calculate the percentage of cost over revenue. The % column is the result that I need. Look like, i cannot nail the total revenue as a fixed number. Once I click on each cost line, the total revenue changes/equal to 0. I appreciate any advice.

 

Service revenue     8,500.0085%
Product revenue     1,500.0015%
Total revenue   10,000.00 100%
Compensation     4,500.0045%
Material and supplies     1,200.0012%
Other expense         600.006%
Total field cost     6,300.00 63%
Shared cost     2,200.00 22%
Total cost     8,500.00 85%
IBT     1,500.00 15%