Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have four cards for different status types. Each are % of the total and technically all add up to 100% but because they are on separate cards and have 0 decimal places the rounding of each of them individually is causing them to not add up to 100%.
I want to put in a check to see if when the 0 decimal % on each card < 100 then to add 1% to one of the cards and if it = > 100% to minus 1% off one of the cards.
Example:
Status 1 | Status 2 | Status 3 | Status 4 | |
10% | 75% | 13% | 1% | 99% |
What's the best way to do this?
Solved! Go to Solution.
Hi @Hayleysea ,
There is a way to solve this problem.
When you calculate the status 4, you can use the 1 - status 1 - status 2 - status 3.
Then I think you will get the result that you want.
Please remember that the status 1/2/3 should be round(status1/2/3,0) I think.
Please try.
Aiolos Zhao
Proud to be a Super User!
@Hayleysea , this typical round off issue. Assume all four of them have values like this
10.2 , 75.3, 13.3, 1.2 . They will round off and you will lose 1.
There best way out is to have 1 decimal place. Or add a rounding error to one number.
Hi @Hayleysea ,
There is a way to solve this problem.
When you calculate the status 4, you can use the 1 - status 1 - status 2 - status 3.
Then I think you will get the result that you want.
Please remember that the status 1/2/3 should be round(status1/2/3,0) I think.
Please try.
Aiolos Zhao
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |