| T O P I C R E V I E W |
| Clairekun |
Posted - 05/18/2020 : 5:01:47 PM
Origin Ver. and Service Release (Select Help-->About Origin): 2018b
Operating System: Win 10
Hello,
I haven't been able to find this anywhere, so sorry if it is stated within Origin help files and the question is redundant.
I have a column where its values are percentages and follow a formula. I have limited the decimals to 2 but, when Origin rounds the numbers automatically, they don't sum 100%. Where/how can I specify this boundary?
Thank you. |
| 2 L A T E S T R E P L I E S (Newest First) |
| Clairekun |
Posted - 07/14/2020 : 6:05:21 PM
I have waited for a while to see if any other replies came up.
I already used round() function, what I need help with is the actual column value correction. Is such a thing possible? Proportional distribution seems like a great idea, but I fail to know how it could be done.
Thank you. |
| aplotnikov |
Posted - 05/18/2020 : 5:50:09 PM
Use round() function https://www.originlab.com/doc/LabTalk/ref/Round-func to calculate column values with the required precision. You may need to define a procedure to correct column values if the sum still differs from 100 - e.g., by proportional distribution of the difference. |
