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
- :
- Discussions
- :
- How do I calculate a ratio with negative numbers

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
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 16, 2017 12:30 PM
(2004 views)

Without using scripting, I want to create a formula that computes a ratio between two columns of CAGR percentages, taking into account that some of the percentages are negative (meaning simple division will not suffice). A formula that might accomplish this is:

If the above formula would work, how would I incorporate the comma in the JMP formula box? Or, is there a better way to compute the ratio?

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 16, 2017 12:42 PM
(3890 views)

Solution

`abs(x-y)/max(abs(x),abs(y))`

The functions are available at:

Help==>Scripting Index==>Functions,

or in the Formula Editor

Jim

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 16, 2017 12:42 PM
(3891 views)

`abs(x-y)/max(abs(x),abs(y))`

The functions are available at:

Help==>Scripting Index==>Functions,

or in the Formula Editor

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 16, 2017 12:51 PM
(1996 views)