Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |