turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Show Scientific notation with Char function?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 1, 2015 8:35 AM
(1949 views)

I have a column that has numbers in scientific notation, I need to annotate a chart title with the values in scientific notation.

To annotate a chart with a number you have to use the Char() function, when I use the Char() function the result is in decimals.

Example:

Dispatch**(** **{}**, "graph title", TextEditBox, **{**Set Text**(** "Id vs Vg by display. Id range : " || Char**(**IR**))}** **)**

** **

Is there anyway to get the Char function to show the Scientific notation instead?

I tried using a new column that was Character based and referenced the values from the numeric column, and JMP promptly turned the new column into a numeric column.

I tried using a new column that was Character based and used the Char() function in the formula, and the scientific notation automatically got converted to decimal.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 1, 2015 8:43 AM
(3536 views)

Solution

x = **5e-10**;

y = Char**(**Format**(**x, "Scientific"**))**;

Show**(**x, y**)**;

**x = 0.0000000005;**

**y = "5e-10";**

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 1, 2015 8:43 AM
(3537 views)

x = **5e-10**;

y = Char**(**Format**(**x, "Scientific"**))**;

Show**(**x, y**)**;

**x = 0.0000000005;**

**y = "5e-10";**

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 1, 2015 8:49 AM
(1768 views)