October 3, 20169 yr 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
October 3, 20169 yr 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.
October 4, 20169 yr Author Thank you very much that did it, even though it doesn't round the number to nearest decimal it still helps lot Much appreciated
October 4, 20169 yr 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, 20169 yr by comment
October 5, 20169 yr Author Thank you for your reply and yes that did it perfectly Thank you very much for your help
Create an account or sign in to comment