Using rounded data in calculationsAppears to be such a simple thing but I have not been able to figure out how to do it - I have a calculations in Column B derived from values in Column A, and in in Column C I want to calculate the natural log of these Column B results (using values to 2 decimal places in scientific or 3 sig figs). I can get JMP to display to what I want but I cannot get the Column C calculations to calculate using rounded/sigfig data.
I am sure there must be a simple way to do this (and I want to avoid copy and pasting from Excel (where it's incredibly simple)) but I have no idea and can't find anything through Google searches.
Data Blending and CleanupQuality and Process EngineeringSharing and Communicating ResultsRe: Using rounded data in calculationsI have figured it out and so will answer my own question, used the following formula:
Ln (Round (As Column ("B"), -4))
Re: Using rounded data in calculationsit looks like your problem may be related to referencing column names.
The column named "B" can be referenced as :B and also as "B"n
Log (Round(:B,-4)). or log (Round("B"n,-4) would work
