Separate card % not adding up to 100%

[Hayleysea]

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?

[amitchandak]

@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.

[AiolosZhao · Accepted 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