Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kaladin
Frequent Visitor

Calculate profit from table

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! 

1 ACCEPTED SOLUTION
WaqarArshad
Helper I
Helper I

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

WaqarArshad_0-1684939903716.png

 

View solution in original post

1 REPLY 1
WaqarArshad
Helper I
Helper I

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

WaqarArshad_0-1684939903716.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.