Fusionista
New Member
- Joined
- Apr 17, 2024
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Hello!
In the attached file the values in column K ("Unique value %) should be rounded to 2 decimal but the "Total %" in column L should still stay exactly 100%.
So I can't use directly the ROUND function, as it messes up the 100 value, like this.
But is there a way to propotionally add/remove value to round the numbers to 2 decimal and keep the total value 100?
Also there could be an instance where there are 3 values all 33,333333%. So rounding them to 100 could be an issue. Right?
So I created a new worksheet with some data. The original worksheet has many-many more rows. But I chose those three clients.
Also started with a helper column S, but have no idea how to continue from there on...
The problems are:
1.The column M should equal 100 for each client, but ALS has only one value in one month. But the calculation still gives 100 for it.
So there's something wrong with the formula?
2. Client UMM has a total of 100,08 in column P, so the excess 0,08 should be distributed between the values of client UMM in column P.
3. Client VAU has a total of 99,99, so 0,01 should be somehow added to one value in column P.
It should continue with extra helper columns, but what should be the next one then?
Uploaded the Excel file here: Easyupload.io - Upload Files and Share Them Easily
In the attached file the values in column K ("Unique value %) should be rounded to 2 decimal but the "Total %" in column L should still stay exactly 100%.
So I can't use directly the ROUND function, as it messes up the 100 value, like this.
But is there a way to propotionally add/remove value to round the numbers to 2 decimal and keep the total value 100?
Also there could be an instance where there are 3 values all 33,333333%. So rounding them to 100 could be an issue. Right?
So I created a new worksheet with some data. The original worksheet has many-many more rows. But I chose those three clients.
Also started with a helper column S, but have no idea how to continue from there on...
The problems are:
1.The column M should equal 100 for each client, but ALS has only one value in one month. But the calculation still gives 100 for it.
So there's something wrong with the formula?
2. Client UMM has a total of 100,08 in column P, so the excess 0,08 should be distributed between the values of client UMM in column P.
3. Client VAU has a total of 99,99, so 0,01 should be somehow added to one value in column P.
It should continue with extra helper columns, but what should be the next one then?
Uploaded the Excel file here: Easyupload.io - Upload Files and Share Them Easily
