Forum Discussion

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

DanLadner1

Qrew Trainee

6 years ago

Try this:

var number leng = Length(ToText([numeric input]));  var number base = ToNumber(Left(ToText([numeric input]),1) & "." & NotLeft(ToText([numeric input]),1));  Left(ToText($base),".") & "." & Right(ToText($base),".") & "^" & ToText($leng-1)