Forum Discussion

RebeccaLutz's avatar
RebeccaLutz
Qrew Trainee
6 years ago

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?
Tables and fields
mmcmanus's avatar
mmcmanus
Qrew Member
9 months ago

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