Scientific Notation
I have many fields that contain data that needs to be displayed in scientific notation. Is there a way to display numbers this way?
Forum Discussion
In case anyone was interested in updates to a 6 year old post, I just discovered that Quickbase can interpret scientific notation within the ToNumber() function now. Using Dan's solution below as an example:
var number base = ToNumber(Left([input],"^")); var number zeroes = ToNumber(Right([input],"^")); $base*(10^$zeroes)
Simplifies to:
var number conversion = ToNumber([input]); $conversion