What is "1e-7" ?

system · November 25, 2010, 5:12pm

I have the following string in one of my company’s webi reports “…[Fixed_currency (TRANSACTION)]<1e-7;[Local Opportunity Amount]…”

What does the “1e-7” part do? I can’t figure it out anywhere.

Help much appreciated!

hendrkle (BOB member since 2010-11-25)

system · November 25, 2010, 11:22pm

1e-7 is another way to write .0000007 in normalized scientific notation. Wikipedia has a good writeup here:

BoB LoblaW (BOB member since 2007-10-23)

system · December 28, 2010, 6:20pm

Correct answer you were looking for is .0000001, and your link says this too.
1e-7 is the same as 1.0 x 10^-7.

CloseButWrong (BOB member since 2010-12-28)

system · December 28, 2010, 10:09pm

Correct. I guess my finger got a little crazy with the ‘7’ key.

BoB LoblaW (BOB member since 2007-10-23)