bioplasma Posted October 3, 2016 Posted October 3, 2016 Hello once again I been trying to make a calculation for the conversion of weight into ml's. Normally I do this by dividing the the weight by 1.026 and the results is the amount in ml's ( 1.026 is the density of blood, plasma, serum ) I have a field for weight and another for volume I want to input the weight and have the result show in volume after being calculated. Thank you in advance for the help and advice
comment Posted October 3, 2016 Posted October 3, 2016 2 hours ago, bioplasma said: I want to input the weight and have the result show in volume after being calculated. Not sure why you're having a problem with this. Simply define Volume as a calculation field, enter the formula = Weight / 1.026 and set the result type to Number.
bioplasma Posted October 4, 2016 Author Posted October 4, 2016 Thank you very much that did it, even though it doesn't round the number to nearest decimal it still helps lot Much appreciated
comment Posted October 4, 2016 Posted October 4, 2016 (edited) 3 hours ago, bioplasma said: it doesn't round the number to nearest decimal You did not mention anything about rounding in your original question; I don't know what "round to nearest decimal" means; usually you round a number to a given precision - i.e. a number of decimal places; You can format the field to display the result as Decimal, with a fixed number of decimals, while retaining the original full precision for further calculations; If you really want to round the result, you can use the Round() function, e.g. = Round ( Weight / 1.026 ; 3 ) to round to 3 decimal places. Edited October 4, 2016 by comment
bioplasma Posted October 5, 2016 Author Posted October 5, 2016 Thank you for your reply and yes that did it perfectly Thank you very much for your help
Recommended Posts
This topic is 3230 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now