Calculate profit from table

[Kaladin]

Hello, 

I have a table that looks like this 

Company    hours     total employee cost     Charged amount
  A         .67              $83                   $4000
  A          1               $125                  $4000
  A          2               $250                  $4000

 I summed the cost and hours now to look like this 

Company    hours     total employee cost     Charged amount
  A         3.67             $458                  $4000

I am trying to find the total profit from the table which would be $4000 - $458 = $3542 however, when i try to calculate this it is taking the charged amount ($4000) and subtractring from each entry of total employee cost. 

I am getting a table that looks like this

Company    hours     total employee cost     Charged amount     Profit
  A         .67              $83                   $4000         $3917 
  A          1               $125                  $4000         $3875
  A          2               $250                  $4000         $3750

The profit is way off and i cannot figure out how to only subtract the charged amount from the total employee cost of all entries in the table. Any help in the right direction is appreciated. Thanks! 

[WaqarArshad · Accepted solution]

When the data is aggregated , the charge amount is multiplied(if summed). You will need to take average of charge amount and subtract  sum of total employee cost to get 3542. See below